Re: Connections getting stuck sending data to client

On Fri, Oct 31, 2008 at 9:36 AM, Chris Butler <chrisb(at)zedcore(dot)com> wrote:
> I've been having intermittent problems with our DB server (running
> postgresql 8.3.3) reaching its connection limit, all because of a SELECT
> statement that's stuck while sending data. This gets stuck because there's a
> transaction waiting to do an ALTER TABLE, then the subsequent SELECTs wait
> for the ALTER.
>
> The problem seems to be that the client connection drops while the server is
> sending data to the client.

Are the clients windows? I know there's a well known and published
bug in windows where it freaks out on blocking ports and the
connection hangs. There's a kb article on it on the ms site. It's
been around since windows 95 or so and there appears to be no plans to
fix it.

If it's not that I'm not sure what it would be.