Re: Problems Vacuum'ing - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Problems Vacuum'ing
Date
Msg-id 20040402203503.GA22171@dcc.uchile.cl
Whole thread Raw
In response to Re: Problems Vacuum'ing  (jseymour@LinxNet.com (Jim Seymour))
Responses Re: Problems Vacuum'ing
List pgsql-hackers
On Fri, Apr 02, 2004 at 02:51:30PM -0500, Jim Seymour wrote:
> > 
> > On Fri, Apr 02, 2004 at 12:02:22PM -0500, Jim Seymour wrote:

> > Ok, so the WebObjects app keeps an idle open transaction?  (i.e. it
> > issues a BEGIN as soon as the previous transaction is finished.) I'm not
> > sure I read the code correctly --
> 
> I really couldn't say.  I don't know what the WebObjects app is
> doing.  I know, or *believe* I know, it's only doing queries.  (It
> may be doing temp tables internally, or some-such.)  Its interface
> to pgsql is via the JDBC that comes with pgsql.  I don't know what
> the Java code it generated looks like.

Turn on query logging and see if the BEGIN is issued right after the
COMMIT/ROLLBACK, or whether it waits and issues it right before
SELECT/CREATE TEMP TABLE.

It doesn't matter if it's only doing queries; if it does them inside a
transaction, it would be enough to keep VACUUM from working "properly."

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"La gente vulgar solo piensa en pasar el tiempo;
el que tiene talento, en aprovecharlo"


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Better support for whole-row operations and composite types
Next
From: Manfred Koizar
Date:
Subject: Re: [GENERAL] Large DB