| 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: | Whole Thread | Raw Message | 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.
>
| 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 ? |