Re: Required checkpoints occurs too frequently

Поиск
Список
Период
Сортировка
От Mohamed Wael Khobalatte
Тема Re: Required checkpoints occurs too frequently
Дата
Msg-id CABZeWdwCp2hZ0dnzunqt5LA-5neFRwyvJZ+snTO3-VS3-gYmtw@mail.gmail.com
обсуждение исходный текст
Ответ на Required checkpoints occurs too frequently  (Atul Kumar <akumar14871@gmail.com>)
Ответы Re: Required checkpoints occurs too frequently
Список pgsql-general


On Fri, Dec 11, 2020 at 3:11 AM Atul Kumar <akumar14871@gmail.com> wrote:
Hi,

We are getting this alert frequently "Required checkpoints occurs too
frequently" on postgres version 11.8

The RAM of the server is 16 GB.

and we have already set the max_wal_size= 4096 MB
min_wal_size= 192 MB.

There are more control settings for checkpoints, such as checkpoint_timeout. Check out the documentation and see if your set values make sense for your case. 

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

Предыдущее
От: Chris Stephens
Дата:
Сообщение: SQL group by help
Следующее
От: Mohamed Wael Khobalatte
Дата:
Сообщение: Re: Required checkpoints occurs too frequently