Tips on TCP socket to postgresql middleware

[eugene]

On Monday, 21 February 2022 at 04:48:56 UTC, Chris Piker wrote:
> On Sunday, 20 February 2022 at 18:36:21 UTC, eugene wrote:
>
>> I often use two connections, one for perform main task
>> (upload some data and alike) and the second for getting
>> notifications from PG, 'cause it very incovinient to
>> do both in a single connection.
>
> Ah, a very handy tip.  It would be convoluted to multiplex 
> notifications
> on the data connection.

I am remembering psql client behavior - it sees notifications 
only after some request. It is really inconvinient to perform 
regular tasks and be ready to peek up notifications at any moment 
in one connection.