Erm, no, it is a Solaris box. And as I could experience, there are rather long timeouts in solaris' tcp implementation. Thanks anyway. What about Postgres. Wouldn't it be better to have postgres sending keep alive or heart beat packages during that time? |-----Original Message----- |From: Dario Brignardello [mailto:dbrignar@xxxxxxxxxxxxxxx] |Sent: Mittwoch, 03. August 2005 19:33 |To: KÖPFERL Robert |Cc: pgsql-admin@xxxxxxxxxxxxxx |Subject: Re: [ADMIN] Blocking connection and timeout problem | | |Assuming you are on a linux box (Not sure if it's stated in your mail, |sorry if I miss that) you could set | |/proc/sys/net/ipv4/tcp_keepalive_time | |to a lower value. That should do the trick :-) | | |Hope it helps. | |Greetings |Dario. | | | |On Wed, 2005-08-03 at 16:48 +0200, KÖPFERL Robert wrote: |> |> |> |> |-----Original Message----- |> |From: Tom Lane [mailto:tgl@xxxxxxxxxxxxx] |> |Sent: Mittwoch, 03. August 2005 16:38 |> |To: KÖPFERL Robert |> |Cc: pgsql-admin@xxxxxxxxxxxxxx |> |Subject: Re: [ADMIN] Blocking connection and timeout problem |> | |> | |> |=?iso-8859-1?Q?K=D6PFERL_Robert?= |<robert.koepferl@xxxxxxxxxx> writes: |> |> Why is that? Why isn't client A's transaction detected as dead ? |> | |> |It will be eventually, when the TCP connection times out. |The standard |> |timeout is generally an hour or two :-( |> |> Seems not like so. I waited for two hours and it still existed. |> |> But non-the-less. Can this timeout be configured to be less? |> |> | |> | regards, tom lane |> | |> |> ---------------------------(end of |broadcast)--------------------------- |> TIP 6: explain analyze is your friend |> |> |-- |Atte: |Dario Brignardello |Planificacion y Desarrollo |Tecnologia |UOL Argentina S.A | |Florida 537 Piso 6, Buenos Aires, Argentina |+54-11-4321-9110 ext 2533 |PGP public key: http://webs.uolsinectis.com.ar/dbrignar/pgp.html |
