Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Wed, 23 Apr 2008 13:08:19 +0000 (GMT)
- Message-id: <264902(dot)97956(dot)qm(at)web25814(dot)mail(dot)ukl(dot)yahoo(dot)com>
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
- Follow-Ups:
- Re: Qty of WAL files
- From: Tom Lane
- Re: Qty of WAL files
- Prev by Date: Re: Need to update all my 60 million rows at once without transactional integrity
- Next by Date: Qty of WAL files
- Previous by thread: Deny creation of tables for a user
- Next by thread: Re: Qty of WAL files
- Indexes: