Re: Listen / Notify - what to do when the queue is full
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Joachim Wieland <joe@mcknight.de>
Cc: pgsql-hackers@postgresql.org
Date: 2009-11-19T00:48:17Z
Lists: pgsql-hackers
Joachim Wieland <joe@mcknight.de> writes: > 4) Allow readers to read uncommitted notifications as well. The question that strikes me here is one of timing --- apparently, readers will now have to check the queue *without* having received a signal? That could amount to an unpleasant amount of extra overhead when the notify system isn't even in use. (Users who don't care about notify will define "unpleasant amount" as "not zero".) I haven't read the patch, so maybe you have some cute solution to that, but if so please explain what. regards, tom lane