Re: PostgreSQL DB checkpoint error!

Поиск
Список
Период
Сортировка
От Rui DeSousa
Тема Re: PostgreSQL DB checkpoint error!
Дата
Msg-id 24FB3FC5-6F7E-4857-8555-C5F96E2F0105@crazybean.net
обсуждение исходный текст
Ответ на RE: PostgreSQL DB checkpoint error!  (Ashok kumar Mani <amani@accelaero.com>)
Список pgsql-admin


On Apr 28, 2020, at 2:49 AM, Ashok kumar Mani <amani@accelaero.com> wrote:  
 
Do I need to restart the postgresql service for log_checkpoints to make it active . I would like to enable this parameter temporarily and check it?
 

Nope, just get it in postgresql.conf and reload it. i.e.   pg_ctl reload 


postgres=# show max_wal_size;
max_wal_size
--------------
2GB
(1 row)

With the deletes, vacuum full, and reindex it is generating WALs at a rapid rate thus trigging another checkpoint given the 2GB size.  The vacuum full and reindex are most likely causing Zabbix to be blocked.  

I would rethink the vacuum full and reindex; before changing max_wal_size. 




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

Предыдущее
От: Rui DeSousa
Дата:
Сообщение: Re: PostgreSQL DB checkpoint error!
Следующее
От: Ashok kumar Mani
Дата:
Сообщение: RE: PostgreSQL DB checkpoint error!