Refactor #16932

Change shared_buffers PostgreSQL options to 25% of available RAM

Added by Stephen Benjamin almost 2 years ago. Updated 7 days ago.

Status:Closed
Priority:Normal
Assignee:Ewoud Kohl van Wijngaarden
Category:External (Puppet Labs) modules
Target version:1.18.0
Difficulty: Team Backlog:
Triaged: Fixed in Releases:
Bugzilla link:1165776 Found in Releases:
Pull request:https://github.com/theforeman/foreman-installer/pull/271

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.

Associated revisions

Revision b1b85f66
Added by Ewoud Kohl van Wijngaarden 3 months ago

Fixes #16932 - Provide default postgresql tuning

History

#1 Updated by Dominic Cleal almost 2 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 (Puppet Labs) modules

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

#2 Updated by Dominic Cleal almost 2 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

#3 Updated by Michael Moll about 1 year ago

Stephen, did anything happen here? :)

#4 Updated by Ewoud Kohl van Wijngaarden 3 months ago

There has been progress:

#5 Updated by The Foreman Bot 3 months ago

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

#6 Updated by Michael Moll 3 months ago

  • Legacy Backlogs Release (now unused) set to 330

#7 Updated by Ewoud Kohl van Wijngaarden 3 months ago

  • % Done changed from 0 to 100
  • Status changed from Ready For Testing to Closed

#8 Updated by Anonymous 8 days ago

  • Target version deleted (1.18.0)

Also available in: Atom PDF