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

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

[...]

> Which is all well-and-good (tho, my ignorance readily conceded, four
> minutes seems a mite... long), *except*: If I shut-down the
> WebObjects application which, again, never accesses the db in
> question, much-less any of its tables, this "time-out" doesn't seem
> to apply.  (I tried it.)

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 -- ISTM it would only matter when you try
to vacuum a shared table, which this is not ...

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"El hombre nunca sabe de lo que es capaz hasta que lo intenta" (C. Dickens)


pgsql-hackers by date:

Previous
From: Joe Conway
Date:
Subject: Re: GiST future
Next
From: Tom Lane
Date:
Subject: Re: GiST future