Re: PostgreSQL questions - Mailing list pgsql-novice

From Gurjeet Singh
Subject Re: PostgreSQL questions
Date
Msg-id 65937bea1003172255x165d2ad9n5b412f87fdde8713@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL questions  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: PostgreSQL questions  (Greg Stark <gsstark@mit.edu>)
List pgsql-novice
On Mon, Mar 15, 2010 at 8:52 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Gurjeet Singh <singh.gurjeet@gmail.com> writes:
> Till Postgres 8.4 the NOTIFY commands could get lost,

That is certainly false.


I meant 'notifications' and not NOTIFY commands.

I haven't looked at the code but picked it from a recent presentation by Addrew Dunstan. The presentation at http://www.pgcon.org/2008/schedule/events/107.en.html looks similar.

Slide 9 says:

Events can be lost!
– If the same event occurs between two calls on
collection by a backend, it will only see one of them
– Because pg_listener has one row per (event,
listener) pair.

And I think these limitations are being remedied by the new implementation in 9.0.

Best regards,
--
gurjeet.singh
@ EnterpriseDB - The Enterprise Postgres Company
http://www.enterprisedb.com

singh.gurjeet@{ gmail | yahoo }.com
Twitter/Skype: singh_gurjeet

Mail sent from my BlackLaptop device

pgsql-novice by date:

Previous
From: Michael Wood
Date:
Subject: Re: Drop table by something other than its name
Next
From: Rainer Schuetz
Date:
Subject: Server not listening... easy fix or workaround?