
> > Tom: If your ratio of physical pages vs WAL records is so bad, the config
> > should simply be changes to do fewer checkpoints (say every 20 min like a 
> > typical Informix setup).
> 
> I was using the default configuration.  What caused the problem was
> probably not so much the standard 5-minute time-interval-driven

I am quite sure, that I would increase the default to at least 15 min here.

> checkpoints, as it was the standard every-3-WAL-segments checkpoints.
> Possibly we ought to increase that number?

Here I am unfortunately not so sure with the current logic (that you can only free 
them after the checkpoint). I think the admin has to choose this. Maybe increase to 4,
but 64 Mb is quite a lot for a small installation :-(

Andreas

Mon, 21 May 2001 18:22:47 +0200
Zeugswetter Andreas SB  <ZeugswetterA@wien.spardat.at>
AW: AW: Plans for solving the VACUUM problem 