Re: PGconn gets frozen ocassionally after select() timeout

Marek Peca <marek@duch.cz> writes:
> However: I can not get the point, why does the PQexec() (or PQstatus() at
> least) hang, instead of returning some error? I know, that situation with
> broken TCP connection may involve long timeouts, but it could return at
> least after several minutes, couldn't it?

"Several hours" might be more like it.  How long have you waited?
In any case, that complaint should be directed to your kernel vendor
not us.  We do not control how long the TCP stack waits before declaring
the connection dead.

            regards, tom lane