Re: BUG #3504: Some listening sessions never return from writing, problems ensue - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #3504: Some listening sessions never return from writing, problems ensue
Date
Msg-id 12248.1186071295@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #3504: Some listening sessions never return from writing, problems ensue  (Peter Koczan <pjkoczan@gmail.com>)
Responses Re: BUG #3504: Some listening sessions never return from writing, problems ensue
List pgsql-bugs
Peter Koczan <pjkoczan@gmail.com> writes:
> Heikki Linnakangas wrote:
>> Does the client read the async notifies? The write in the server will
>> block if the client doesn't keep up with reading the data.
>>
> Well, the client updates it's GUI properly no matter whether the
> listening session is blocked or not (it's an ongoing tail of requests).
> Overtly from the client side, it's completely transparent. Is there any
> way I can tell definitively from the client side whether or not it's
> actually reading the async notifies?

netstat's Recv-Q column would probably reflect it if the client is
failing to consume messages.  The send queue on the server side would be
worth checking too.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Peter Koczan
Date:
Subject: Re: BUG #3504: Some listening sessions never return from writing, problems ensue
Next
From: Heikki Linnakangas
Date:
Subject: Re: BUG #3506: to_number silently ignore characters