Re: Optimize LISTEN/NOTIFY - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Optimize LISTEN/NOTIFY
Date
Msg-id 1459429.1764101848@sss.pgh.pa.us
Whole thread Raw
In response to Re: Optimize LISTEN/NOTIFY  ("Joel Jacobson" <joel@compiler.org>)
List pgsql-hackers
"Joel Jacobson" <joel@compiler.org> writes:
> It looks to me like it would be best with two boolean fields; one
> boolean to stage the updates during PreCommit_Notify, that each
> pendingActions could flip back and forth, and another boolean that
> represents the current value, which we would overwrite with the staged
> value during AtCommit_Notify.

+1, I had a feeling that a single boolean wouldn't quite do it.
(There are various ways we could define the states, but what
you say above seems pretty reasonable.)

            regards, tom lane



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [PATCH] Add mssql_compat extension with DATEDIFF function
Next
From: Peter Eisentraut
Date:
Subject: Re: [PATCH] Add native PIVOT syntax for SQL Server/Oracle compatibility