Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql General > Qty of WAL file...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 1 Topic 15367 of 17602
Post > Topic >>

Qty of WAL files

by glynastill@[EMAIL PROTECTED] (Glyn Astill) Apr 23, 2008 at 01:08 PM

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


--=20
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
 




 1 Posts in Topic:
Qty of WAL files
glynastill@[EMAIL PROTECT  2008-04-23 13:08:20 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Dec 1 19:14:09 CST 2008.