> > 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