Project

General

Profile

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

Also available in: Atom PDF