Thread: Qty of WAL files

Hi chaps,

I've set the checkpoint_segments on our system to 20 in anticipation of our system being quite write heavy, and I was
wonderingif someone could give me the lowdown on the amount of WAL files created and how they're re-used. 

I've just read in a large amount of data into the database and as expected quite a few WAL files were generated.

Will the amount of WAL files ever be decreased automagically?


      __________________________________________________________
Sent from Yahoo! Mail.
A Smarter Email http://uk.docs.yahoo.com/nowyoucan.html

Glyn Astill <glynastill@yahoo.co.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
wonderingif 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