| From: | Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Qty of WAL files |
| Date: | 2008-04-23 13:08:20 |
| Message-ID: | 13176.83515.qm@web25815.mail.ukl.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kerri Reno | 2008-04-23 13:23:01 | Re: FW: Re: create temp in function |
| Previous Message | Glyn Astill | 2008-04-23 13:08:19 | Qty of WAL files |