Re: nonremovable row ?

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Hervé Piedvache <herve(at)elma(dot)fr>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: nonremovable row ?
Date: 2005-05-04 16:58:47
Message-ID: 20050504165847.GC30968@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, May 04, 2005 at 18:24:53 +0200,
Hervé Piedvache <herve(at)elma(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Benjamin Smith 2005-05-04 18:48:44 Postgres vs Firebird?
Previous Message Bruno Wolff III 2005-05-04 16:46:29 Re: [INTERFACES] calculated identity field in views, again...