| From: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
|---|---|
| To: | Greg Patnude <gpatnude(at)hotmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Checkpoints are occurring too frequently... |
| Date: | 2005-07-12 18:05:22 |
| Message-ID: | 1121191522.8208.231.camel@state.g2switchworks.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, 2005-07-12 at 13:04, Greg Patnude wrote:
> 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 ???
Lots of updates or inserts.
What are you doing with your database? Are you running some application
that is doing a lot of small inserts maybe?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tony Caduto | 2005-07-12 18:13:34 | Re: Windows version of PostgreSQL 8.x? |
| Previous Message | Greg Patnude | 2005-07-12 18:04:31 | Checkpoints are occurring too frequently... |