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/