Re: nonremovable row ? - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: nonremovable row ?
Date
Msg-id 20050504165847.GC30968@wolff.to
Whole thread Raw
In response to nonremovable row ?  (Hervé Piedvache <herve@elma.fr>)
List pgsql-general
On Wed, May 04, 2005 at 18:24:53 +0200,
  Hervé Piedvache <herve@elma.fr> wrote:
>
> Why I get 26927405 nonremovable row versions in 185707 pages ?
> How to remove them ? I need to free the space quickly !

Those rows will still be visible to transactions that started before
the delete was committed. Once all those transactions have committed
or rolled back, then you can free up the space with a vacuum full.

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: [INTERFACES] calculated identity field in views, again...
Next
From: Benjamin Smith
Date:
Subject: Postgres vs Firebird?