Re: Update and some verbose output

R. Willmington wrote:

> In fact, it seems to perform well and removes the deleted records.
> The problem is  that the performance of queries against the table is
> as low as it was before i ran VACUUM FULL for the first time in a
> year,
> whereas performance on the staging system with the SAME database and
> the exact same data was dramatically increased.

Have you tried to reindex the table? (\help REINDEX)

If table indexes have grown very big, I think just vacuum full is not
enough. At least you could try and see, if it makes a difference.

Regards,
Michael Paesold