Re: notification: pg_notify ?

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