On 07/15/2013 04:10 PM, Greg Jaskiewicz wrote:
In terms of features, apart from separating LISTEN so that it can be actually used on Standbys, wouldn't it be a matter of including the notifications in the WAL stream, as simple packets ? This would guarantee same behaviour as on the master.
I guess one problem is to implement writing to the WAL with the smallest possible performance hit. As far as I can see there are two possible approaches: either write to WAL when NOTIFY is run or write to WAL on commit. The former seems more in line with how commands in PostgreSQL usually work.
There shouldn't be any major problems with implementing LISTEN on the slaves since LISTEN is done in memory.
I feel like I as a beginner to the codebase am missing something bit because while this is a fair bit of work it does not too hard to implement.
Andreas -- Andreas Karlsson -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
