difference between checkpoint_segments and wal_keep_segments inpostgres configuration file

Поиск
Список
Период
Сортировка
От Raghavendra Rao J S V
Тема difference between checkpoint_segments and wal_keep_segments inpostgres configuration file
Дата
Msg-id CAEHH7R7dSEka9StaNaHPV=72NLHfBkBreC2pqihWzCi-LRysng@mail.gmail.com
обсуждение исходный текст
Ответы Re: difference between checkpoint_segments and wal_keep_segments inpostgres configuration file  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-general
Дерево обсуждения
I am not clear the difference between  checkpoint_segments and wal_keep_segments .

I would like to now below things. Please explain.Thanks in advance.

  • Difference  between checkpoint_segments and wal_keep_segments value 
  • Role  of  checkpoint_segments and wal_keep_segments 
  • Which one should has higher value.
-- 
Regards,
Raghavendra Rao J S V

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

Предыдущее
От: Raghavendra Rao J S V
Дата:
Сообщение: Suggest the best values for the postgres configuration parameters
Следующее
От: Raghavendra Rao J S V
Дата:
Сообщение: Planning to change autovacuum_vacuum_scale_factor value to zero.Please suggest me if any negative impact.