Refactor #16932: Change shared_buffers PostgreSQL options to 25% of available RAM - Installer - Foreman

Actions

Copy link

Refactor #16932

closed

Change shared_buffers PostgreSQL options to 25% of available RAM

Added by Stephen Benjamin about 8 years ago. Updated over 6 years ago.

Status:

Closed

Priority:

Normal

Assignee:

Ewoud Kohl van Wijngaarden

Category:

External modules

Target version:

1.18.0

Difficulty:

Triaged:

Bugzilla link:

1165776

Pull request:

https://github.com/theforeman/foreman-installer/pull/271

Fixed in Releases:

Found in Releases:

Red Hat JIRA:

Description

Cloned from https://bugzilla.redhat.com/show_bug.cgi?id=1165776
Description of problem:

Installed Satellite 6 on RHEL 6.5 and RHEL 7 and the postgres configuration is set to the default settings. Ex shared_buffers is 32MB and recommendation from postgres documentation is 25% of available RAM. Since Satellite 6 houses two databases with different workloads in postgres (foreman and candlepin) we need to assess configuration changes that best support performance for both databases.

This BZ is to track any suggested configuration changes to postgres for satellite 6.

Actions

Copy link

Updated by Dominic Cleal about 8 years ago

Project changed from Foreman to Installer
Subject changed from Foreman installs postgres with default configuration to Foreman installs postgres with default configuration
Category set to External modules

This should be filed in the Puppet MODULES project if it the default values should be changed.

Actions

Copy link

Updated by Dominic Cleal about 8 years ago

Tracker changed from Bug to Refactor
Subject changed from Foreman installs postgres with default configuration to Change shared_buffers PostgreSQL options to 25% of available RAM

Actions

Copy link

Updated by Anonymous over 7 years ago

Stephen, did anything happen here? :)

Actions

Copy link

Updated by Ewoud Kohl van Wijngaarden over 6 years ago

There has been progress:

https://github.com/theforeman/foreman-installer/commit/a6300830b37ddc1685348a135e4e79d7472ff9be allows overriding it via hiera
https://github.com/theforeman/foreman-installer/pull/271 changes the default to 512MB. While not 25%, should we consider this good enough that it fixes it?

Actions

Copy link

Updated by The Foreman Bot over 6 years ago

Status changed from New to Ready For Testing
Assignee set to Ewoud Kohl van Wijngaarden
Pull request https://github.com/theforeman/foreman-installer/pull/271 added