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

From Tom Lane
Subject Re: Problems Vacuum'ing
Date
Msg-id 9804.1080952520@sss.pgh.pa.us
Whole thread Raw
In response to Re: Problems Vacuum'ing  (jseymour@LinxNet.com (Jim Seymour))
Responses Re: Problems Vacuum'ing  (jseymour@LinxNet.com (Jim Seymour))
Re: Problems Vacuum'ing  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List pgsql-hackers
jseymour@LinxNet.com (Jim Seymour) writes:
> Again the difference: With WebObjects running, deleting rows and
> trying to vacuum immediately, even full, fails.  Shut-down WebObjects
> and I can.

WebObjects is evidently holding an open transaction.  Ergo, anything
deleted after the start of that transaction isn't vacuumable.  You need
to do something about the client-side logic that is holding an open
transaction without doing anything ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Function to kill backend
Next
From: Manfred Koizar
Date:
Subject: Re: [GENERAL] Large DB