Project

General

Profile

Refactor #16932

Change shared_buffers PostgreSQL options to 25% of available RAM

Added by Stephen Benjamin almost 2 years ago. Updated 2 months ago.

Status:
Closed
Priority:
Normal
Category:
External (Puppet Labs) modules
Target version:
Difficulty:
Triaged:
Bugzilla link:
Team Backlog:
Fixed in Releases:
Found in Releases:

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 (diff)
Added by Ewoud Kohl van Wijngaarden 5 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 over 1 year ago

Stephen, did anything happen here? :)

#4 Updated by Ewoud Kohl van Wijngaarden 5 months ago

There has been progress:

#5 Updated by The Foreman Bot 5 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 5 months ago

  • Legacy Backlogs Release (now unused) set to 330

#7 Updated by Ewoud Kohl van Wijngaarden 5 months ago

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

#8 Updated by Anonymous 2 months ago

  • Target version deleted (1.18.0)

Also available in: Atom PDF