| From: | jtv <jtv(at)xs4all(dot)nl> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Tom Ivar Helbekkmo <tih(at)kpnQwest(dot)no>, Bruce Badger <bbadger(at)BadgerSE(dot)com>, pgsql-interfaces(at)postgresql(dot)org |
| Subject: | Re: Beating Oracle |
| Date: | 2002-03-02 11:22:18 |
| Message-ID: | 20020302122218.A5730@xs4all.nl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Kretzer | 2002-03-02 13:04:19 | Re: pg_select in a tcl script |
| Previous Message | ljb | 2002-03-02 02:08:48 | Re: pg_select in a tcl script |