Re: Vacuum Full + Cluster + Vacuum full = non removable dead rows

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Alexandre de Arruda Paes <adaldeia(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Vacuum Full + Cluster + Vacuum full = non removable dead rows
Date: 2010-08-17 19:24:29
Message-ID: AANLkTikZb-9XaC5=-fKNPYEK7J_q97Kjq9nsM=3kwgV2@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, Aug 17, 2010 at 1:19 PM, Alexandre de Arruda Paes
<adaldeia(at)gmail(dot)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/

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Mark Kirkwood 2010-08-17 22:27:45 Re: Very poor performance
Previous Message Alexandre de Arruda Paes 2010-08-17 19:19:32 Vacuum Full + Cluster + Vacuum full = non removable dead rows