Re: Very long time to commit or close connections

From: "Chris Smith" <cdsmith(at)twu(dot)net>
To: "Erwan Arzur" <erwan(at)free(dot)fr>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Very long time to commit or close connections
Date: 2004-01-19 15:03:18
Message-ID: 02a301c3de9d$5fefd210$6f00000a@KYA
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris Smith 2004-01-19 15:12:38 Re: Very long time to commit or close connections
Previous Message Federico Pedemonte 2004-01-19 14:41:00 How to get the requested columns in a rowtype PL/pgSQL function