From: | Selva manickaraja <mavles78(at)gmail(dot)com> |
---|---|
To: | Stephen Frost <sfrost(at)snowman(dot)net> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Too many WAL(s) despite low transaction |
Date: | 2011-04-01 01:31:22 |
Message-ID: | AANLkTi=U_2opbk3Kg223=++V9EfK5KGw-M-28Ec0dxCe@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)snowman(dot)net> wrote:
> * Selva manickaraja (mavles78(at)gmail(dot)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-----
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Stephen Frost | 2011-04-01 01:38:53 | Re: Too many WAL(s) despite low transaction |
Previous Message | Stephen Frost | 2011-04-01 01:03:36 | Re: Too many WAL(s) despite low transaction |