Re: setting high value for wal_keep_segments

Поиск
Список
Период
Сортировка
От Jov
Тема Re: setting high value for wal_keep_segments
Дата
Msg-id CADyrUxN48LENqaGkbV6h7VacwarGM4HFNouZnXnb+Vcv3n91Hg@mail.gmail.com
обсуждение исходный текст
Ответ на setting high value for wal_keep_segments  (AI Rumman <rummandba@gmail.com>)
Список 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@gmail.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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: How to prevent clear screen when query finish ?
Следующее
От: "ascot.moss@gmail.com"
Дата:
Сообщение: How to find transaction ID