Postgres Pro
Downloads
Home   >   mailing lists

Re: VACUUM FULL hangs on ordinary table - Mailing list pgsql-general

From Joachim Wieland
Subject Re: VACUUM FULL hangs on ordinary table
Date
Msg-id 20060519170322.GA2713@mcknight.de
Whole thread Raw
In response to VACUUM FULL hangs on ordinary table  ("Ivan Zolotukhin" <ivan.zolotukhin@gmail.com>)
List pgsql-general
Tree view 
On Fri, May 19, 2006 at 03:58:19PM +0400, Ivan Zolotukhin wrote:
> There are no clients connected to the
> database except me in that moment since I switched application to
> another DB.

Did you check for not yet committed prepared transactions?
Check the pg_prepared_xacts system view.


Joachim

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: allow LIMIT in UPDATE and DELETE
Next
From: Shelby Cain
Date:
Subject: Re: allow LIMIT in UPDATE and DELETE