Re: Large transaction problem - Mailing list pgsql-admin

From Andrew Sullivan
Subject Re: Large transaction problem
Date
Msg-id 20041112155728.GB32479@phlogiston.dyndns.org
Whole thread Raw
In response to Re: Large transaction problem  ("Paul B. Anderson" <paul@pnlassociates.com>)
List pgsql-admin
On Fri, Nov 12, 2004 at 10:30:27AM -0500, Paul B. Anderson wrote:
> When the vacuum full timed out, could the exclusive lock have been left
> set, leaving the database in an unusable state?

No, but cancelling a VACUUM FULL takes a long time, in my experience,
and so the lock hangs around for quite a while.

> BTW, thanks.  I removed the --full option.

My bet is that will help matters.

A

--
Andrew Sullivan  | ajs@crankycanuck.ca
In the future this spectacle of the middle classes shocking the avant-
garde will probably become the textbook definition of Postmodernism.
                --Brad Holland

pgsql-admin by date:

Previous
From: "Paul B. Anderson"
Date:
Subject: Re: Large transaction problem
Next
From: Vida Luz
Date:
Subject: Consult is very slow