PostgreSQL - checkpoints are occurring too frequently

Solution Verified - Updated -

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.

Current Customers and Partners

Log in for full access

Log In