set log_rotation_size when enabling log_min_duration_statement for PostgreSQL
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.
A reasonable log_rotation_size should be set to prevent /var/lib/pgsql being filled up.
#4 Updated by Suresh Thirugnanasambandan 6 months ago
- Status changed from Ready For Testing to Closed
Applied in changeset installer|6c51031394a361247eb8da7f0dd7b3ffabd88144.