Skip site navigation (1) Skip section navigation (2)

Re: postgresql idle

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
Cc: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: postgresql idle
Date: 2004-04-29 23:23:24
Message-ID: 17949.1083281004@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-general
Andrew Sullivan <ajs(at)crankycanuck(dot)ca> writes:
> On Thu, Apr 29, 2004 at 03:57:59PM -0400, Andrew Rawnsley wrote:
>> I find that some clients (DBVisualizer for one) do exactly that - 
>> execute the COMMIT;BEGIN sequence, and leaves idle
>> transactions on a consistent basis.

> Almost all the things I've see that set the autocommit behaviour will
> also do this.  I suspect it's a pretty common approach.

Yeah.  We agreed in principle awhile back to "fix" this on the backend
side by postponing the actual transaction start until the first command
after BEGIN.  I looked at this just before 7.4 feature freeze, but
decided it wasn't quite trivial and I hadn't time to make it happen.
No one's gone back to work on it during the 7.5 cycle either.

Right now I'm not wanting to touch that code since both Alvaro and the
2PC guy have open patches against it...

			regards, tom lane

In response to

Responses

pgsql-general by date

Next:From: Tom LaneDate: 2004-04-29 23:28:39
Subject: Re: Timestamp problems...wrong weeks.
Previous:From: DeJuan JacksonDate: 2004-04-29 23:10:41
Subject: Re: Timestamp problems...wrong weeks.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group