On Fri, Oct 31, 2008 at 9:36 AM, Chris Butler <[EMAIL PROTECTED]> 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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
