Skip site navigation (1) Skip section navigation (2)

Re: LISTEN/NOTIFY and notification timing guarantees

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jeff Davis <pgsql(at)j-davis(dot)com>
Cc: Joachim Wieland <joe(at)mcknight(dot)de>, Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: LISTEN/NOTIFY and notification timing guarantees
Date: 2010-02-16 21:13:02
Message-ID: 14895.1266354782@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers 
Jeff Davis <pgsql(at)j-davis(dot)com> writes:
> On Tue, 2010-02-16 at 10:38 -0500, Tom Lane wrote:
>> 2. Add an extra lock to serialize writers to the queue, so that messages
>> are guaranteed to be added to the queue in commit order.

> I assume this is a heavyweight lock, correct?

Yeah, that seems the easiest way to do it.  I think an LWLock could be
made to work, but releasing it on error might be a bit funky.

			regards, tom lane

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2010-02-16 21:15:11
Subject: Re: LISTEN/NOTIFY and notification timing guarantees
Previous:From: Bruce MomjianDate: 2010-02-16 21:07:03
Subject: Re: psql 8.4 \c repeats version banner

Privacy Policy | About PostgreSQL
Copyright © 1996-2013 The PostgreSQL Global Development Group