Re: Notify enhancement

Поиск
Список
Период
Сортировка
Искать
От
Alvaro Herrera
Тема
Re: Notify enhancement
Дата
Msg-id
20061215212627.GU14237@alvh.no-ip.org
Ответ на
Re: Notify enhancement (Andrew Dunstan)
Список
Дерево обсуждения
Notify enhancement Andrew Dunstan <andrew@dunslane.net>
Re: Notify enhancement Alvaro Herrera <alvherre@commandprompt.com>
Re: Notify enhancement Andrew Dunstan <andrew@dunslane.net>
Re: Notify enhancement "Greg Sabino Mullane" <greg@turnstep.com>
Re: Notify enhancement Tom Lane <tgl@sss.pgh.pa.us>
Re: Notify enhancement "Greg Sabino Mullane" <greg@turnstep.com>
Re: Notify enhancement "Andrew Dunstan" <andrew@dunslane.net>
Re: Notify enhancement Tom Lane <tgl@sss.pgh.pa.us>
Re: Notify enhancement Andrew Dunstan <andrew@dunslane.net>
Re: Notify enhancement Alvaro Herrera <alvherre@commandprompt.com>
Re: Notify enhancement Andrew Dunstan <andrew@dunslane.net>
Re: Notify enhancement Tom Lane <tgl@sss.pgh.pa.us>
Re: Notify enhancement Andrew Dunstan <andrew@dunslane.net>
Re: Notify enhancement Tom Lane <tgl@sss.pgh.pa.us>
Re: Notify enhancement "Florian G. Pflug" <fgp@phlo.org>
Re: Notify enhancement Tom Lane <tgl@sss.pgh.pa.us>
Re: Notify enhancement Gregory Stark <stark@enterprisedb.com>
Re: Notify enhancement Tom Lane <tgl@sss.pgh.pa.us>
Re: Notify enhancement Alvaro Herrera <alvherre@commandprompt.com>
Re: Notify enhancement Tom Lane <tgl@sss.pgh.pa.us>
Re: Notify enhancement Matteo Beccati <php@beccati.com>
Re: Notify enhancement Guillaume Lelarge <guillaume@lelarge.info>
Andrew Dunstan wrote:


> I don't understand how we decide that everybody who needs a given 
> event+message has got it, if we don't know who (if anyone) is listening? 
> How do we decide that we no longer need the info in the shmem buffer? 

Keep a pointer in shared memory for each listener backend, saying how
far it has scanned the ring?  There would be a single writing pointer,
so it's trivial to see when the ring is "full".

> Timeout? sinval issues a reset if the buffer becomes full, but we can't 
> do that here.

Just have NOTIFY block when the buffer is full, and maybe issue a
warning so that the user knows that he should increase the ring size.


> Are we keeping use of SIGUSR2 in this scheme?

What for?  Just protect the write pointer with a lwlock and have
listeners check whether somebody has written something.

В списке pgsql-hackers по дате отправления
От: Andrew Dunstan
Дата:
Сообщение: Re: Notify enhancement
От: Tom Lane
Дата:
Сообщение: Re: Notify enhancement
FAQ