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 of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
