Re: VACUUM FULL hangs on ordinary table

From: Joachim Wieland <joe(at)mcknight(dot)de>
To: iz(at)sai(dot)msu(dot)ru
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: VACUUM FULL hangs on ordinary table
Date: 2006-05-19 17:03:23
Message-ID: 20060519170322.GA2713@mcknight.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Shelby Cain 2006-05-19 17:25:19 Re: allow LIMIT in UPDATE and DELETE
Previous Message Tom Lane 2006-05-19 16:57:23 Re: allow LIMIT in UPDATE and DELETE