Re: [BUGS] BUG #14830: Missed NOTIFications, PostgreSQL 9.1.24

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [BUGS] BUG #14830: Missed NOTIFications, PostgreSQL 9.1.24
Дата
Msg-id 18082.1507647266@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [BUGS] BUG #14830: Missed NOTIFications, PostgreSQL 9.1.24  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [BUGS] BUG #14830: Missed NOTIFications, PostgreSQL 9.1.24  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Дилян Палаузов
Дата:
Сообщение: [BUGS] ./configure error: Cannot find a working 64-bit integer type
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [BUGS] ./configure error: Cannot find a working 64-bit integer type