Re: Impact of checkpointer during pg_upgrade - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: Impact of checkpointer during pg_upgrade
Date
Msg-id ZPqNxqAnsocq41Ih@paquier.xyz
Whole thread Raw
In response to Re: Impact of checkpointer during pg_upgrade  (Amit Kapila <amit.kapila16@gmail.com>)
Responses RE: Impact of checkpointer during pg_upgrade
List pgsql-hackers
On Fri, Sep 08, 2023 at 08:18:14AM +0530, Amit Kapila wrote:
> This validation tries to ensure that we don't have any bugs/issues in
> our patch. It may be a candidate for assert but I feel even if we
> encounter any bug it is better to fix the bug.

My guess is that an elog-like error is more adapted so as we are able
to detect problems in more cases, but perhaps an assert may be enough
for the buildfarm.  If there is anything in the backend that causes
slots to become invalidated, I agree that any issue causing that
should be fixed, but isn't the point different here?  Having a check
at the end of an upgrade is a mean to improve the detection rate of
bugs where slots get invalidated, so it is actually helpful to have
one anyway?  I am not sure what is your strategy here, do you mean to
keep a check at the end of pg_upgrade only in the patch to validate
it?  Or do you mean to add something in pg_upgrade as part of the
feature?  I mean that doing the latter is benefitial for the sake of
any patch committed and as a long-term method to rely on.
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: Impact of checkpointer during pg_upgrade
Next
From: "Zhijie Hou (Fujitsu)"
Date:
Subject: RE: Impact of checkpointer during pg_upgrade