Re: Background writer and checkpointer in crash recovery - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: Background writer and checkpointer in crash recovery
Date
Msg-id YyAHy4UrE1YeY/bt@paquier.xyz
Whole thread Raw
In response to Re: Background writer and checkpointer in crash recovery  (Justin Pryzby <pryzby@telsasoft.com>)
Responses Re: Background writer and checkpointer in crash recovery
List pgsql-hackers
On Mon, Sep 12, 2022 at 09:13:11PM -0500, Justin Pryzby wrote:
> Like this, maybe.
>
> It's similar to what I suggested to consider backpatching here:
> https://www.postgresql.org/message-id/20201214032224.GA30237%40telsasoft.com

At the same time, df9274adf has been done because the end-of-recovery
checkpoint done potentially by the startup process if the checkpointer
was not up at the end of recovery would take long.  Any of the actions
taken in the startup process when finishing recovery are not that
costly, on the contrary, as far as I know.

I am not opposed to clearing the ps display when we are at this state
of the game for the startup process, but rather than clearing it we
could switch provide something more useful that shows what's
happening.  Say a simple "performing end-of-recovery actions", for
example..
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Assertion failure in WaitForWALToBecomeAvailable state machine
Next
From: Julien Rouhaud
Date:
Subject: Re: Query Jumbling for CALL and SET utility statements