Checkpoints are occurring too frequently... - Mailing list pgsql-general

From Greg Patnude
Subject Checkpoints are occurring too frequently...
Date
Msg-id db10ai$u3o$1@news.hub.org
Whole thread Raw
Responses Re: Checkpoints are occurring too frequently...
List pgsql-general
LOG:  checkpoints are occurring too frequently (19 seconds apart)
HINT:  Consider increasing the configuration parameter
"checkpoint_segments".
LOG:  checkpoints are occurring too frequently (12 seconds apart)
HINT:  Consider increasing the configuration parameter
"checkpoint_segments".
LOG:  checkpoints are occurring too frequently (12 seconds apart)
HINT:  Consider increasing the configuration parameter
"checkpoint_segments".
LOG:  checkpoints are occurring too frequently (11 seconds apart)
HINT:  Consider increasing the configuration parameter
"checkpoint_segments".
LOG:  checkpoints are occurring too frequently (12 seconds apart)
HINT:  Consider increasing the configuration parameter
"checkpoint_segments".

What does this mean and what causes it ???



pgsql-general by date:

Previous
From: Douglas McNaught
Date:
Subject: Re: Transaction Handling in pl/pgsql
Next
From: Scott Marlowe
Date:
Subject: Re: Windows version of PostgreSQL 8.x?