Qty of WAL files

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:19
Message-ID: 264902.97956.qm@web25814.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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Glyn Astill 2008-04-23 13:08:20 Qty of WAL files
Previous Message Alvaro Herrera 2008-04-23 13:04:29 Re: Need to update all my 60 million rows at once without transactional integrity