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.
Since this issue was entered in Red Hat Bugzilla, the release flag has been set to ? to ensure that it is properly evaluated for this release.
Per 6.3 planning, moving out non acked bugs to the backlog
Created redmine issue http://projects.theforeman.org/issues/16932 from this bug
Thank you for your interest in Satellite 6. We have evaluated this request, and we do not expect this to be implemented in product in the foreseeable future. We are therefore closing this out as WONTFIX. If you have any concerns about this, please feel free to contact Rich Jerrido or Bryan Kearney. Thank you.
Reopening.
Upstream bug assigned to ekohlvan
Moving this bug to POST for triage into Satellite 6 since the upstream issue http://projects.theforeman.org/issues/16932 has been resolved.
Verified using psql on Sat 6.4 snap 7
Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory, and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. https://access.redhat.com/errata/RHSA-2018:2927