Re: Is there any impact if "#wal_keep_segments = 0 " and"checkpoint_segments = 128" postgresql.conf file.

Поиск
Список
Период
Сортировка
От Raghavendra Rao J S V
Тема Re: Is there any impact if "#wal_keep_segments = 0 " and"checkpoint_segments = 128" postgresql.conf file.
Дата
Msg-id CAEHH7R6go_JyOYoKyazZhAR3vDte1HtLadVxL4_L41Es08OXnA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Is there any impact if "#wal_keep_segments = 0 " and"checkpoint_segments = 128" postgresql.conf file.  ("Jehan-Guillaume (ioguix) de Rorthais" <ioguix@free.fr>)
Список pgsql-general
Дерево обсуждения
Thanks a lot. 

On Mon, 15 Oct 2018 at 14:43, Jehan-Guillaume (ioguix) de Rorthais <ioguix@free.fr> wrote:
On Mon, 15 Oct 2018 09:46:47 +0200
Laurenz Albe <laurenz.albe@cybertec.at> wrote:

> Raghavendra Rao J S V wrote:
> > Is there any impact if  "#wal_keep_segments = 0 " and "checkpoint_segments
> > = 128" postgresql.conf file. If yes,what is the imapct? 
>
> Yes.
> - You will have fewer checkpoints requested by data modification activity.
> - Crash recovery might take longer.

And considering wal_keep_segments, there is no impact on perf/recovery. This
mostly related to the standby replication lag allowed and some other solutions
exists (slots, archiving).


--
Regards,
Raghavendra Rao J S V
Mobile- 8861161425

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

Предыдущее
От: "Jehan-Guillaume (ioguix) de Rorthais"
Дата:
Сообщение: Re: Is there any impact if "#wal_keep_segments = 0 " and"checkpoint_segments = 128" postgresql.conf file.
Следующее
От: Durgamahesh Manne
Дата:
Сообщение: Re: Regarding varchar max length in postgres