Re: PostgreSQL questions

Поиск
Список
Период
Сортировка
От Gurjeet Singh
Тема Re: PostgreSQL questions
Дата
Msg-id 65937bea1003172255x165d2ad9n5b412f87fdde8713@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PostgreSQL questions  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: PostgreSQL questions  (Greg Stark <gsstark@mit.edu>)
Список 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 по дате отправления:

Предыдущее
От: Michael Wood
Дата:
Сообщение: Re: Drop table by something other than its name
Следующее
От: Rainer Schuetz
Дата:
Сообщение: Server not listening... easy fix or workaround?