Re: Checkpoints are occurring too frequently...
| От | Scott Marlowe |
|---|---|
| Тема | Re: Checkpoints are occurring too frequently... |
| Дата | |
| Msg-id | 1121191522.8208.231.camel@state.g2switchworks.com обсуждение исходный текст |
| Ответ на | Checkpoints are occurring too frequently... ("Greg Patnude" <gpatnude@hotmail.com>) |
| Список | 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?
В списке pgsql-general по дате отправления: