Re: checkpoint occurs very often when vacuum full running

Поиск
Список
Период
Сортировка
От Sergei Kornilov
Тема Re: checkpoint occurs very often when vacuum full running
Дата
Msg-id 6028761542309042@myt3-c573aa6fc782.qloud-c.yandex.net
обсуждение исходный текст
Ответ на checkpoint occurs very often when vacuum full running  (Mariel Cherkassky <mariel.cherkassky@gmail.com>)
Ответы Re: checkpoint occurs very often when vacuum full running  (Mariel Cherkassky <mariel.cherkassky@gmail.com>)
Re: checkpoint occurs very often when vacuum full running  (Mariel Cherkassky <mariel.cherkassky@gmail.com>)
Список pgsql-admin
Hi

Checkpoint can be occurs due timeout (checkpoint_timeout) or due amount of WAL (max_wal_size).
Vacuum full does write all data through WAL and therefore may trigger checkpoint more frequently.

regards, Sergei


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Can't find a relation in pg_class
Следующее
От: Mariel Cherkassky
Дата:
Сообщение: Re: checkpoint occurs very often when vacuum full running