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