Project

General

Profile

Actions

Feature #28497

closed

set log_rotation_size when enabling log_min_duration_statement for PostgreSQL

Added by Suresh Thirugnanasambandan almost 5 years ago. Updated almost 5 years ago.

Status:
Closed
Priority:
Normal
Category:
-
Target version:
-
Difficulty:
Triaged:
No
Fixed in Releases:
Found in Releases:

Description

Cloned from https://bugzilla.redhat.com/show_bug.cgi?id=1770646

Description of problem:

BZ#1749233 is going to set log_min_duration_statement=1000 for PostgreSQL by default. However, this has a possible side effect on a large deployment where /var/lib/pgsql is mounted separately. The /var/lib/pgsql can be easily filled up
when slow queries are identified. For example, a slow query for selecting facts could consume a large space when there are many facts on a host.

Expected results:

A reasonable log_rotation_size should be set to prevent /var/lib/pgsql being filled up.

Actions #1

Updated by Suresh Thirugnanasambandan almost 5 years ago

  • Assignee changed from Ewoud Kohl van Wijngaarden to Suresh Thirugnanasambandan
Actions #2

Updated by The Foreman Bot almost 5 years ago

  • Status changed from New to Ready For Testing
  • Pull request https://github.com/theforeman/foreman-installer/pull/432 added
Actions #3

Updated by The Foreman Bot almost 5 years ago

  • Fixed in Releases 2.0.0 added
Actions #4

Updated by Suresh Thirugnanasambandan almost 5 years ago

  • Status changed from Ready For Testing to Closed
Actions

Also available in: Atom PDF