Re: WAL Optimisation - configuration and usage

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: WAL Optimisation - configuration and usage
Дата
Msg-id 24768.1078189289@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: WAL Optimisation - configuration and usage  ("Simon Riggs" <simon@2ndquadrant.com>)
Ответы Re: WAL Optimisation - configuration and usage  ("Simon Riggs" <simon@2ndquadrant.com>)
Список pgsql-performance
"Simon Riggs" <simon@2ndquadrant.com> writes:
> - why checkpoint interval of 300 secs causes them to happen every 10
> mins in quieter periods; is that an occaisional update occurring?

There is code in there to suppress a checkpoint if no WAL-loggable
activity has happened since the last checkpoint.  Not sure if that's
relevant to the issue or not though.

            regards, tom lane

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

Предыдущее
От: "Simon Riggs"
Дата:
Сообщение: Re: WAL Optimisation - configuration and usage
Следующее
От: postgres@countup.de
Дата:
Сообщение: Re: Select-Insert-Query