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

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: Is there any impact if "#wal_keep_segments = 0 " and"checkpoint_segments = 128" postgresql.conf file.
Дата
Msg-id 2e2ea4412f3067e69be85758f6f624be33fd1362.camel@cybertec.at
обсуждение исходный текст
Ответ на Is there any impact if "#wal_keep_segments = 0 " and"checkpoint_segments = 128" postgresql.conf file.  (Raghavendra Rao J S V <raghavendrajsv@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
Дерево обсуждения 
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.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com

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

Предыдущее
От: Raghavendra Rao J S V
Дата:
Сообщение: Is there any impact if "#wal_keep_segments = 0 " and"checkpoint_segments = 128" postgresql.conf file.
Следующее
От: Rijo Roy
Дата:
Сообщение: Enabling autovacuum per table