PostgreSQL - checkpoints are occurring too frequently
Issue
The following messages occur regularly in our /var/lib/pgsql/data/pg_log/postgresql*-log files:
LOG: checkpoints are occurring too frequently (4 seconds apart)
HINT: Consider increasing the configuration parameter "checkpoint_segments".
Environment
Red Hat Enterprise Linux 5, 6, 7
PostgreSQL 8, 9
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.
