Re: Is there a way (except from server logs) to know the kind of on-going/last checkpoint? - Mailing list pgsql-hackers

From Julien Rouhaud
Subject Re: Is there a way (except from server logs) to know the kind of on-going/last checkpoint?
Date
Msg-id 20220128020046.6nq55y4jo6wysiqt@jrouhaud
Whole thread Raw
In response to Re: Is there a way (except from server logs) to know the kind of on-going/last checkpoint?  (Kyotaro Horiguchi <horikyota.ntt@gmail.com>)
Responses Re: Is there a way (except from server logs) to know the kind of on-going/last checkpoint?
Re: Is there a way (except from server logs) to know the kind of on-going/last checkpoint?
List pgsql-hackers
Hi,

On Fri, Jan 28, 2022 at 10:38:53AM +0900, Kyotaro Horiguchi wrote:
> 
> I'd like to see the PID of the triggering process, but it is really
> not a information suitable in the control file...

Yes that's something I would like too.  But even if the PIDs could be store, I
don't think that having the information for an already completed checkpoint
would be of any use at all.

For the current checkpoint, it should also be an array of PID.  For instance if
the checkpointer started a throttled checkpoint, then someone calls a non
immediate pg_start_backup() and finally thinks it's too slow and need a fast
checkpoint.  This would be welcome in a new pg_stat_progress_checkpoint view.



pgsql-hackers by date:

Previous
From: Thomas Munro
Date:
Subject: Re: Creation of an empty table is not fsync'd at checkpoint
Next
From: Kyotaro Horiguchi
Date:
Subject: Re: Is there a way (except from server logs) to know the kind of on-going/last checkpoint?