Re: setting high value for wal_keep_segments

From: Jov <zhao6014(at)gmail(dot)com>
To: AI Rumman <rummandba(at)gmail(dot)com>
Cc: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: setting high value for wal_keep_segments
Date: 2013-08-08 13:40:15
Message-ID: CADyrUxN48LENqaGkbV6h7VacwarGM4HFNouZnXnb+Vcv3n91Hg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

no problem if you have enough space. we have set it to 4096 one year
ago,everything is OK.

jov
在 2013-8-8 下午9:26,"AI Rumman" <rummandba(at)gmail(dot)com>写道:

> 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.
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message ascot.moss@gmail.com 2013-08-08 13:52:05 How to find transaction ID
Previous Message Adrian Klaver 2013-08-08 13:39:31 Re: How to prevent clear screen when query finish ?