Qty of WAL files - Mailing list pgsql-general

From Glyn Astill
Subject Qty of WAL files
Date
Msg-id 264902.97956.qm@web25814.mail.ukl.yahoo.com
Whole thread Raw
Responses Re: Qty of WAL files  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Need to update all my 60 million rows at once without transactional integrity
Next
From: Glyn Astill
Date:
Subject: Qty of WAL files