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