From: | Magnus Hagander <magnus(at)hagander(dot)net> |
---|---|
To: | Andrey Borodin <x4mmm(at)yandex-team(dot)ru> |
Cc: | Daniel Gustafsson <daniel(at)yesql(dot)se>, Michael Banck <michael(dot)banck(at)credativ(dot)de>, Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Greg Stark <stark(at)mit(dot)edu>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Online enabling of checksums |
Date: | 2018-03-19 11:57:42 |
Message-ID: | CABUevEzFbfOtVu36smPwEDvA6x0PWfR7Oa1vUbFey=DPREq-+A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Mon, Mar 19, 2018 at 12:24 PM, Magnus Hagander <magnus(at)hagander(dot)net>
wrote:
> On Mon, Mar 19, 2018 at 11:40 AM, Andrey Borodin <x4mmm(at)yandex-team(dot)ru>
> wrote:
>
>> Hi, Daniel!
>>
>> > 19 марта 2018 г., в 4:01, Daniel Gustafsson <daniel(at)yesql(dot)se>
>> написал(а):
>> >
>> > Fixed in patch just posted in 84693D0C-772F-45C2-88A1-85B498
>> 3A5780(at)yesql(dot)se
>> > (version 5). Thanks!
>>
>>
>> I've been hacking a bit in neighboring thread.
>> And come across one interesting thing. There was a patch on this CF on
>> enabling checksums for SLRU. The thing is CLOG is not protected with
>> checksums right now. But the bad thing about it is that there's no reserved
>> place for checksums in SLRU.
>> And this conversion from page without checksum to page with checksum is
>> quite impossible online.
>>
>> If we commit online checksums before SLRU checksums, we will need very
>> neat hacks if we decide to protect SLRU eventually.
>>
>> What do you think about this problem?
>>
>
> One would be adjusted to work with the other, yes. It makes no sense to
> now allow online enabling once SLRU protection is in there, and it doesn't
> make sense for either of these patches to be blocking the other one for
> commit, though it would of course be best to get both included.
>
Makes no sense to *not* allow it, of course. Meaning yes, that should be
handled.
We don' t need to convert from "page format with no support for checksums"
(pre-11) to "page format with support for checksums" (11+) online.
We do need to convert from "page format with support for checksums but no
checksums enabled" (11+) to "checksums enabled" online.
--
Magnus Hagander
Me: https://www.hagander.net/ <http://www.hagander.net/>
Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>
From | Date | Subject | |
---|---|---|---|
Next Message | Andrey Borodin | 2018-03-19 12:08:02 | Re: Online enabling of checksums |
Previous Message | Masahiko Sawada | 2018-03-19 11:50:48 | Re: [HACKERS] GUC for cleanup indexes threshold. |