checkpoint_timeout irrelevant in 8.1.9
| От | George Wilk |
|---|---|
| Тема | checkpoint_timeout irrelevant in 8.1.9 |
| Дата | |
| Msg-id | 002501c7b360$267ac1c0$0d7ba8c0@ellacoya.com обсуждение исходный текст |
| Ответы |
Re: checkpoint_timeout irrelevant in 8.1.9
Re: checkpoint_timeout irrelevant in 8.1.9 |
| Список | pgsql-admin |
According to the WAL config documentation correctly, checkpoints are created every checkpoint_segments log segments, or every checkpoint_timeout seconds, whichever comes first. However, it seems as though setting my checkpoint_timeout has no effect on checkpoint creation ( I have it set to 30 seconds). Forcing checkpoint by running psql –c CHECKPOINT mydb doesn’t do the trick either. Checkpoints are created solely based on the checkpoint_segments logs reaching their configured size.
This is not satisfactory in a low transaction volume environment. Any hints on how else can I trigger checkpoint?
Thanks in advance,
~george
В списке pgsql-admin по дате отправления: