On Tue, Aug 17, 2010 at 1:19 PM, Alexandre de Arruda Paes <adaldeia@xxxxxxxxx> 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/ -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
