setting high value for wal_keep_segments

From: AI Rumman <rummandba(at)gmail(dot)com>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: setting high value for wal_keep_segments
Date: 2013-08-08 13:23:49
Message-ID: CAGoODpcGmcV44tTdaeXGjn_kOztxE=zL-H6mX7gQvN2B2-Zi5A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Thanks.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2013-08-08 13:39:31 Re: How to prevent clear screen when query finish ?
Previous Message hubert depesz lubaczewski 2013-08-08 08:55:18 Re: Performance of ORDER BY RANDOM to select random rows?