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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
