Checkpoint taking long

From: Yambu <hyambu(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Checkpoint taking long
Date: 2021-07-20 07:17:11
Message-ID: CALhHtcC8k4_H2RCXiEHXat6_AuSO3tiAB_sYLd=6FGi5W2ATQQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello

Can i kill a checkpoint process that has been running for 8hrs, below are
from pg_stat_activity

wait_event_type=IO
wait_event=DataFileFlush
backend_type=checkpointer

regards

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Holger Jakobs 2021-07-20 08:01:41 Re: postgresql.auto.conf
Previous Message Yambu 2021-07-20 07:08:16 postgresql.auto.conf