From: Tom Lane <tgl@sss.pgh.pa.us>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Amit Kapila <amit.kapila16@gmail.com>
Cc: amul sul <sulamul@gmail.com>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: [Patch] ALTER SYSTEM READ ONLY
Date: Wed, 17 Jun 2020 12:45:45 -0400
Message-ID: <1449608.1592412345@sss.pgh.pa.us> (raw)
In-Reply-To: <CA+TgmobDe3Z_ZdxSAyxchZXFeUrqTMTT83w4ooqwiBpgNKfaJw@mail.gmail.com>
References: <CAAJ_b97KZzdJsffwRK7w0XU5HnXkcgKgTR69t8cOZztsyXjkQw@mail.gmail.com>
<CAA4eK1+5BDNS08XKXR7UPkq4tDaV66wyZia4kDMvRUm=a_A=Gg@mail.gmail.com>
<1445158.1592405895@sss.pgh.pa.us>
<CA+TgmobHeJ0Bg0QmgTtpO2AvmJOQOgafHf__UNcCQKA2ybyYQw@mail.gmail.com>
<1448927.1592411268@sss.pgh.pa.us>
<CA+TgmobDe3Z_ZdxSAyxchZXFeUrqTMTT83w4ooqwiBpgNKfaJw@mail.gmail.com>
Robert Haas <robertmhaas@gmail.com> writes:
> On Wed, Jun 17, 2020 at 12:27 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Which of the things I mentioned don't require writing WAL?
> Writing hint bits and marking index tuples as killed do not write WAL
> unless checksums are enabled.
And your point is? I thought enabling checksums was considered
good practice these days.
>> You're right that these are the same things that we already forbid on a
>> standby, for the same reason, so maybe it won't be as hard to identify
>> them as I feared. I wonder whether we should envision this as "demote
>> primary to standby" rather than an independent feature.
> See my comments on the nearby pg_demote thread. I think we want both.
Well, if pg_demote can be done for X amount of effort, and largely
gets the job done, while this requires 10X or 100X the effort and
introduces 10X or 100X as many bugs, I'm not especially convinced
that we want both.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: tgl@sss.pgh.pa.us, robertmhaas@gmail.com, amit.kapila16@gmail.com, sulamul@gmail.com
Subject: Re: [Patch] ALTER SYSTEM READ ONLY
In-Reply-To: <1449608.1592412345@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox