Project

General

Profile

Bug #27846

by default 'log_min_duration = 1000' should be configured for PostgreSQL

Added by Ewoud Kohl van Wijngaarden 7 months ago. Updated 6 months ago.

Status:
Closed
Priority:
Normal
Category:
-
Target version:
-

Description

To gather more data when checking support cases, having 'log_min_duration = 1000' in PostgreSQL config by default would be great.

Expected results:
'log_min_duration = 500' should be in PostgreSQL config file on both freshly installed and upgraded Satellite:

  1. grep log_min_duration /var/lib/pgsql/data/postgresql.conf

Additional info:
Tuning profiles already have 'log_min_duration = 500'
https://github.com/RedHatSatellite/satellite-support/tree/master/tuning-profiles

Note this can be also achieved via /etc/foreman-installer/custom-hiera.yaml by:

postgresql::server::config_entries:
log_min_duration_statement: 1000

By including it as default, users can only disable it by setting the value to -1 in custom-hiera.yaml.

Associated revisions

Revision 27cae009 (diff)
Added by Ewoud Kohl van Wijngaarden 7 months ago

Fixes #27846 - Add Postgresql log_min_duration

With this change, queries taking longer than a second will be logged.
This makes it easier to debug performance issues.

Users can disable this by setting the value to -1 via another hiera
layer.

Revision f0b57e89 (diff)
Added by Ewoud Kohl van Wijngaarden 6 months ago

Refs #27846 - Correct log_min_duration_statement

Due to a copy paste error an invalid configuration option was used. This
corrects it to the actual configuration option.

History

#1 Updated by The Foreman Bot 7 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/389 added

#2 Updated by The Foreman Bot 7 months ago

  • Fixed in Releases 1.24.0 added

#3 Updated by Ewoud Kohl van Wijngaarden 7 months ago

  • Status changed from Ready For Testing to Closed

#4 Updated by The Foreman Bot 6 months ago

  • Pull request https://github.com/theforeman/foreman-installer/pull/392 added

Also available in: Atom PDF