| From: | Rui DeSousa <rui(at)crazybean(dot)net> |
|---|---|
| To: | Ashok kumar Mani <amani(at)accelaero(dot)com> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>, "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: PostgreSQL DB checkpoint error! |
| Date: | 2020-04-28 07:01:47 |
| Message-ID: | 24FB3FC5-6F7E-4857-8555-C5F96E2F0105@crazybean.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
> On Apr 28, 2020, at 2:49 AM, Ashok kumar Mani <amani(at)accelaero(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ashok kumar Mani | 2020-04-28 07:06:31 | RE: PostgreSQL DB checkpoint error! |
| Previous Message | Rui DeSousa | 2020-04-28 06:50:23 | Re: PostgreSQL DB checkpoint error! |