Postgres Pro
Downloads
Home   >   mailing lists

setting high value for wal_keep_segments - Mailing list pgsql-general

From AI Rumman
Subject setting high value for wal_keep_segments
Date
Msg-id CAGoODpcGmcV44tTdaeXGjn_kOztxE=zL-H6mX7gQvN2B2-Zi5A@mail.gmail.com
Whole thread Raw
Responses Re: setting high value for wal_keep_segments  (Jov <zhao6014@gmail.com>)
Re: setting high value for wal_keep_segments  (bricklen <bricklen@gmail.com>)
List pgsql-general
Tree view
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.

pgsql-general by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: Performance of ORDER BY RANDOM to select random rows?
Next
From: Adrian Klaver
Date:
Subject: Re: How to prevent clear screen when query finish ?