Re: [BUGS] BUG #14830: Missed NOTIFications, PostgreSQL 9.1.24 - Mailing list pgsql-bugs

From Tom Lane
Subject Re: [BUGS] BUG #14830: Missed NOTIFications, PostgreSQL 9.1.24
Date
Msg-id 18082.1507647266@sss.pgh.pa.us
Whole thread Raw
In response to Re: [BUGS] BUG #14830: Missed NOTIFications, PostgreSQL 9.1.24  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [BUGS] BUG #14830: Missed NOTIFications, PostgreSQL 9.1.24  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
I wrote:
> ... I'm a bit hesitant to put a GetSnapshotData
> call into ProcessIncomingNotify, because of the possibility of adding a
> lot of contention on the ProcArray if there's very heavy notify traffic.

Wait, I have an idea.  Let's fetch a snapshot at the top of
ProcessIncomingNotify, and then use the snapshot to decide whether
xids are running, instead of calling TransactionIdIsInProgress.

GetSnapshotData is probably a bit heavier than a single
TransactionIdIsInProgress call, but if we have to process multiple
messages then this should be a net savings in ProcArray traffic.
        regards, tom lane


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

pgsql-bugs by date:

Previous
From: Дилян Палаузов
Date:
Subject: [BUGS] ./configure error: Cannot find a working 64-bit integer type
Next
From: Tom Lane
Date:
Subject: Re: [BUGS] ./configure error: Cannot find a working 64-bit integer type