Re: transaction idle timeout in 7.4.5 and 8.0.0beta2

From: "Jeroen T(dot) Vermeulen" <jtv(at)xs4all(dot)nl>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: transaction idle timeout in 7.4.5 and 8.0.0beta2
Date: 2004-09-18 16:49:47
Message-ID: 20040918164946.GA71269@xs4all.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sat, Sep 18, 2004 at 12:43:05PM -0400, Tom Lane wrote:

> I don't see any reason for guesswork. Remember the PID of the backend
> you were connected to. On reconnect, look in pg_stat_activity to see if
> that backend is still alive; if so, sleep till it's not. Then check to
> see if your transaction committed or not. No need for anything so
> dangerous as a timeout.

I didn't know you could do that! I'll look into it. Thanks.

Jeroen

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-09-18 17:01:42 Re: tweaking MemSet() performance - 7.4.5
Previous Message Tom Lane 2004-09-18 16:43:05 Re: transaction idle timeout in 7.4.5 and 8.0.0beta2