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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend