Ühel kenal päeval, T, 2007-03-27 kell 07:11, kirjutas Andrew Dunstan:
> Hannu Krosing wrote:
> > So perhaps it Alvaros proposal can be rephrased thus:
> > "Why have the name on each message? The names are already stored in
> > listen table, just reuse numeric identifier pointing to item in that
> > table. That gives you room for a lot more messages."
> >
> > If there is no name in listen table, it means that nobody is interested
> > and the message can be dropped right away.
> >
> >   
> Er, what listen table? 

equivalent of pg_listener, see my mail with attached .sql

> The only thing that will be in shared memory is a 
> queue and some bookkeeping (queue head per backend). Each backend will 
> be responsible for catching the notifications it is interested in and 
> discarding the rest 

At least the list of which backends listen to which events should be
also in shared mem.

How else would we know how many copies to make for each backend or when
we can release the memory in case we make one copy ?

> (see earlier discussion).

could you post a link to archives ?

I could not find anything relevant in the discussion link from the head
of this mail thread.

> cheers
> andrew
Hannu Krosing
Database Architect
Skype Technologies OÜ
Akadeemia tee 21 F, Tallinn, 12618, Estonia

Skype me:  callto:hkrosing
Get Skype for free:  http://www.skype.com

NOTICE: This communication contains privileged or other confidential
information. If you have received it in error, please advise the sender
by reply email and immediately delete the message and any attachments
without copying or disclosing the contents.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly

Reply via email to