Re: Very long time to commit or close connections - Mailing list pgsql-general

From Chris Smith
Subject Re: Very long time to commit or close connections
Date
Msg-id 02a301c3de9d$5fefd210$6f00000a@KYA
Whole thread Raw
In response to Very long time to commit or close connections  ("Chris Smith" <cdsmith@twu.net>)
List pgsql-general
Erwin,

> Could this be related to a network problem ?
>
> Like RST not received by the client, making it believe the server did
> not acknowledge the connection.close(), eating up the server's resources
> ? No firewall/VPN gateways between you and your customer ?

Nice thought, but the app and database are on the same box, and communicating
via TCP/IP on the localhost address.  I'm not sure it's even possible to set
up a firewall there, and I'm certain it hasn't been done.

Thanks,

--
www.designacourse.com
The Easiest Way to Train Anyone... Anywhere.

Chris Smith - Lead Software Developer/Technical Trainer
MindIQ Corporation


pgsql-general by date:

Previous
From: Federico Pedemonte
Date:
Subject: How to get the requested columns in a rowtype PL/pgSQL function
Next
From: "Chris Smith"
Date:
Subject: Re: Very long time to commit or close connections