Re: postgresql idle

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>, pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: postgresql idle
Date: 2004-04-30 01:54:08
Message-ID: 200404300154.i3U1s8P00687@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Is this a TODO?

---------------------------------------------------------------------------

Tom Lane wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kris Jurka 2004-04-30 02:21:47 Re: postgresql idle
Previous Message Tatsuo Ishii 2004-04-30 01:20:32 Re: Postgre and Web Request