>>>>> "Martijn" == Martijn van Oosterhout <klep...@svana.org> writes:
>> Hi, >> >> Attached is a patch for a new listen/notify implementation. >> >> In a few words, the patch reimplements listen/notify as an >> slru-based queue which works similar to the sinval >> structure. Essentially it is a ring buffer on disk with pages >> mapped into shared memory for read/write access. Martijn> While I can't really comment on the implementation, from your Martijn> description it looks like a big improvement. Does it cope with the case where a trigger is doing NOTIFY, and you do a whole-table update, therefore dumping potentially millions of notifications in at once? (for example a rare maintenance operation on a table which has a listen/notify arrangement triggered by single inserts or updates) The existing implementation copes with that just fine. -- Andrew (irc:RhodiumToad) -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
