Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk> writes:
> I've set the checkpoint_segments on our system to 20 in anticipation of our system being quite write heavy, and I was wondering if someone could give me the lowdown on the amount of WAL files created and how they're re-used.
http://www.postgresql.org/docs/8.3/static/wal-configuration.html
(Adjust link for your PG version, as the rules were different in earlier
versions.)
regards, tom lane