Re: notification payloads

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Hannu Krosing <hannu(at)skype(dot)net>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Dave Page <dpage(at)postgresql(dot)org>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: notification payloads
Date: 2007-03-27 11:11:03
Message-ID: 4608FBC7.8060402@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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? 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 (see earlier discussion).

cheers

andrew

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message alfranio correia junior 2007-03-27 11:11:49 Re: Re: [PATCHES] As proposed the complete changes to pg_trigger and pg_rewrite
Previous Message Andrew Dunstan 2007-03-27 11:06:30 Re: notification payloads