listen/notify support with transaction pooling

[chasers]

Inspired by allas

Use a single connection to proxy listen notify requests to all clients.

[JanRuettinger]

It looks that right now listen notify requests open new connections and eventually overflow the system. Is there a work around?

[psteinroe]

+1. can confirm that listen notify also overflows the system.

[chasers]

What do you all mean "overflow the system"?

Since listen requires a connection per listen command if you listen to too many topics you can create too many connections.

Don't listen to more topics than your pool_size and make sure to use session mode (for now).

[psteinroe]

What do you all mean "overflow the system"?

Since listen requires a connection per listen command if you listen to too many topics you can create too many connections.

Don't listen to more topics than your pool_size and make sure to use session mode (for now).

If I remember correctly it was something on my side. Either wrong mode or just too many listeners due to falsy settings on the client side.

not an issue for me anymore.