Postgres Pro
Downloads
Home   >   mailing lists

Re: Too many WAL(s) despite low transaction - Mailing list pgsql-admin

From Selva manickaraja
Subject Re: Too many WAL(s) despite low transaction
Date
Msg-id AANLkTi=U_2opbk3Kg223=++V9EfK5KGw-M-28Ec0dxCe@mail.gmail.com
Whole thread Raw
In response to Re: Too many WAL(s) despite low transaction  (Stephen Frost <sfrost@snowman.net>)
Responses Re: Too many WAL(s) despite low transaction  (Stephen Frost <sfrost@snowman.net>)
List pgsql-admin
Tree view
If our check_timeout is 30 minutes, what would be an acceptable time limit for archive_timeout?

Also since bulk loading/migration of large amount of data was done earlier, do I need to run vacuum etc.

I will wait for your reply.

Thank you.

Regards,

Selvam

On Fri, Apr 1, 2011 at 9:03 AM, Stephen Frost <sfrost@snowman.net> wrote:
* Selva manickaraja (mavles78@gmail.com) wrote:
> I'm attaching the file here. As of now it is 874 files within 3 hours.

You have archive_timeout set to '5'.  That means "rotate a log file
every 5 seconds".  You probably want to increase that.

       Thanks

               Stephen

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)

iEYEARECAAYFAk2VJGgACgkQrzgMPqB3kigM7QCfZ0qTMlLfCpksmAXogWo80ezn
QkQAn1VT2I+y+eMeaoIFEMdeEsnN+uN5
=lynD
-----END PGP SIGNATURE-----


pgsql-admin by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Too many WAL(s) despite low transaction
Next
From: Stephen Frost
Date:
Subject: Re: Too many WAL(s) despite low transaction