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: | Raw Message | Whole Thread | 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 |