Postgres Pro
Downloads
Home   >   mailing lists

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

From Stephen Frost
Subject Re: Too many WAL(s) despite low transaction
Date
Msg-id 20110401010336.GB4116@tamriel.snowman.net
Whole thread Raw
In response to Re: Too many WAL(s) despite low transaction  (Selva manickaraja <mavles78@gmail.com>)
Responses Re: Too many WAL(s) despite low transaction  (Selva manickaraja <mavles78@gmail.com>)
List pgsql-admin
Tree view 
* 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
Attachment

pgsql-admin by date:

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