Re: Beating Oracle - Mailing list pgsql-interfaces

From jtv
Subject Re: Beating Oracle
Date
Msg-id 20020302122218.A5730@xs4all.nl
Whole thread Raw
In response to Re: Beating Oracle  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-interfaces
On Fri, Mar 01, 2002 at 02:40:06PM -0500, Tom Lane wrote:
> 
> I have been wondering about whether Bruce's problem is firewall
> misbehavior.  In particular, if there's a NAT translation happening
> anywhere between his client and his server, then the firewall could
> break the connection by dropping that particular port mapping, which
> perhaps it might do if there's no activity for awhile.  In this case,
> it might actually be that the default KEEPALIVE timeout of 2 hours is
> too long for us :-(.  (RFC 1122 says that the timeout shall be
> configurable, but this requirement seems to be widely ignored.)

If that turns out to be the case, sending null queries periodically
should help some.


Jeroen



pgsql-interfaces by date:

Previous
From: ljb
Date:
Subject: Re: pg_select in a tcl script
Next
From: Andreas Kretzer
Date:
Subject: Re: pg_select in a tcl script