Re: [ADMIN] checkpoint_timeout irrelevant in 8.1.9

2007-06-20 Thread Alvaro Herrera
George Wilk wrote: > According to the WAL config documentation correctly, checkpoints are created > every > admin3.chm::/pg/runtime-config-wal.html#guc-checkpoint-segments> > checkpoint_segments log segments, or every > admin3.chm::/pg/runtime-config-wal.html#guc-checkpoint-timeout> > checkpoint_

Re: [ADMIN] checkpoint_timeout irrelevant in 8.1.9

2007-06-20 Thread Joshua D. Drake
George Wilk wrote: 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_se

[ADMIN] checkpoint_timeout irrelevant in 8.1.9

2007-06-20 Thread George Wilk
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 se