Re: Online checksums patch - once again - Mailing list pgsql-hackers

From Daniel Gustafsson
Subject Re: Online checksums patch - once again
Date
Msg-id F6013369-420F-4A71-99EA-483FCB3432D4@yesql.se
Whole thread Raw
In response to Re: Online checksums patch - once again  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
> On 26 Jun 2020, at 14:12, Robert Haas <robertmhaas@gmail.com> wrote:
>
> On Thu, Jun 25, 2020 at 5:43 AM Daniel Gustafsson <daniel@yesql.se> wrote:
>> Sorry being a bit thick, can you elaborate which case you're thinking about?
>> CREATE TABLE sets the attribute according to the value of data_checksums, and
>> before enabling checksums (and before changing data_checksums to inprogress)
>> the bgworker will update all relhaschecksums from true (if any) to false.  Once
>> the state is set to inprogress all new relations will set relhaschecksums to
>> true.
>
> Oh, I think I was the one who was confused. I guess relhaschecksums
> only really has meaning when we're in the process of enabling
> checksums? So if we're in that state, then the Boolean tells us
> whether a particular relation is done, and otherwise it doesn't
> matter?

That is correct (which is why the name is terrible since it doesn't convey
that at all).

cheers ./daniel


pgsql-hackers by date:

Previous
From: Daniel Gustafsson
Date:
Subject: Re: should libpq also require TLSv1.2 by default?
Next
From: Amit Langote
Date:
Subject: ModifyTable overheads in generic plans