Re: Vacuum Full + Cluster + Vacuum full = non removable dead rows - Mailing list pgsql-performance

On Tue, Aug 17, 2010 at 1:19 PM, Alexandre de Arruda Paes
<adaldeia@gmail.com> wrote:
> Hi,
>
> PG 8.4.4
> I did't see any transactions locking this table and I think that CLUSTER
> will recreate the table.

Prepared transactions?

> This is a temporary table, with one DELETE, Some INSERTs and a lot of
> UPDATES. And the UPDATES become slow and slow every time.
> The only way to correct, is truncating the table.

And you're sure there aren't any "idle in transaction" connections/