Re: [Patch] ALTER SYSTEM READ ONLY

From: Amul Sul <sulamul(at)gmail(dot)com>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Andres Freund <andres(at)anarazel(dot)de>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [Patch] ALTER SYSTEM READ ONLY
Date: 2020-11-23 06:36:45
Message-ID: CAAJ_b943WyELMs+iwMbbZf-xtjmTQwkHHNr33y7vmX6s5ndR8Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Nov 20, 2020 at 11:13 PM Amul Sul <sulamul(at)gmail(dot)com> wrote:
>
> On Fri, 20 Nov 2020 at 9:53 PM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
>>
>> On Thu, Oct 8, 2020 at 6:23 AM Amul Sul <sulamul(at)gmail(dot)com> wrote:
>> > On a quick look at the latest 0001 patch, the following hunk to reset leftover
>> > flags seems to be unnecessary:
>> >
>> > + /*
>> > + * If some barrier types were not successfully absorbed, we will have
>> > + * to try again later.
>> > + */
>> > + if (!success)
>> > + {
>> > + ResetProcSignalBarrierBits(flags);
>> > + return;
>> > + }
>> >
>> > When the ProcessBarrierPlaceholder() function returns false without an error,
>> > that barrier flag gets reset within the while loop. The case when it has an
>> > error, the rest of the flags get reset in the catch block. Correct me if I am
>> > missing something here.
>>
>> Good catch. I think you're right. Do you want to update accordingly?
>
>
> Sure, Ill update that. Thanks for the confirmation.
>

Attached is the updated version where unnecessary ResetProcSignalBarrierBits()
call in 0001 patch is removed. The rest of the patches are unchanged, thanks.

>>
>> Andres, do you like the new loop better?
>>

Regards,
Amul

Attachment Content-Type Size
v11-0004-Implement-ALTER-SYSTEM-READ-ONLY-using-global-ba.patch application/octet-stream 41.8 KB
v11-0005-Error-or-Assert-before-START_CRIT_SECTION-for-WA.patch application/octet-stream 70.2 KB
v11-0002-Test-module-for-barriers.-NOT-FOR-COMMIT.patch application/octet-stream 3.9 KB
v11-0001-Allow-for-error-or-refusal-while-absorbing-barri.patch application/octet-stream 7.4 KB
v11-0006-WIP-Documentation.patch application/octet-stream 6.5 KB
v11-0003-Add-alter-system-read-only-write-syntax.patch application/octet-stream 9.3 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bharath Rupireddy 2020-11-23 06:48:42 Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit
Previous Message Greg Nancarrow 2020-11-23 05:04:45 Re: Parallel plans and "union all" subquery