Re: Too many WAL(s) despite low transaction

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Selva manickaraja <mavles78(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Too many WAL(s) despite low transaction
Date: 2011-04-01 01:03:36
Message-ID: 20110401010336.GB4116@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

* 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Selva manickaraja 2011-04-01 01:31:22 Re: Too many WAL(s) despite low transaction
Previous Message Selva manickaraja 2011-04-01 01:00:41 Re: Too many WAL(s) despite low transaction