Tom Lane wrote:
> There is a very significant performance problem with LISTEN/NOTIFY
> via pg_listener: in any application that generates notifications at
> a significant rate, pg_listener will accumulate dead tuples at that
> same rate, and we will soon find ourselves wasting lots of time
> scanning through dead tuples. Frequent VACUUMs might help, but the
That's unfortunate, may be if backend could reuse tuple on updates could help?
> whole thing is really quite silly: why are we using a storage mechanism
> that's designed entirely for *stable* storage of data to pass inherently
> *transient* signals? If the system crashes, we have absolutely zero
Because there is no other easy way to guarantee message delivery?
> interest in the former contents of pg_listener (and indeed need to go
> to some trouble to get rid of them).
There is no free beer :)
Regards,
Mikhail Terekhov