Re: Too many WAL(s) despite low transaction
| От | Selva manickaraja |
|---|---|
| Тема | Re: Too many WAL(s) despite low transaction |
| Дата | |
| Msg-id | AANLkTi=U_2opbk3Kg223=++V9EfK5KGw-M-28Ec0dxCe@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Too many WAL(s) despite low transaction (Stephen Frost <sfrost@snowman.net>) |
| Ответы |
Re: Too many WAL(s) despite low transaction
|
| Список | 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
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 по дате отправления: