Re: setting high value for wal_keep_segments - Mailing list pgsql-general

From AI Rumman
Subject Re: setting high value for wal_keep_segments
Date
Msg-id CAGoODpccHUfWPdJYEbP5K9eKJSPM_EoGUnbfqiPETsSWc8etdw@mail.gmail.com
Whole thread Raw
In response to Re: setting high value for wal_keep_segments  (bricklen <bricklen@gmail.com>)
List pgsql-general
Yeah, I already set it like that and it works.
Thanks.


On Thu, Aug 8, 2013 at 11:59 AM, bricklen <bricklen@gmail.com> wrote:
On Thu, Aug 8, 2013 at 6:23 AM, AI Rumman <rummandba@gmail.com> wrote:
Hi,

I am going to sync slave with my master which is almost 500 G. I am not using archive directory instead of I am using wal files for streaming. As it may take almost 3 hours, I am thinking of setting up 400 for wal_keep_segments where I have enough space available.

Without the space issue, could there be any other problem in setting up such high value for "wal_keep_segments"? As this is production, I need to confirmed.

Another data point: I set up SR on two systems recently in production with the wal_keep_segments set to 10000 (lots of logs were being generated), and the slaves were about 1TB each. No problems were experienced.


pgsql-general by date:

Previous
From: bricklen
Date:
Subject: Re: setting high value for wal_keep_segments
Next
From: Kevin Grittner
Date:
Subject: Re: How to avoid Force Autovacuum