On 23/03/2011 12:24 PM, Chris wrote:
You'll need to reindex that table now - vacuum full can bloat your indexes which will affect your other queries.
It doesn't seem to matter much for a one-off. Index bloat problems have mainly been encountered where people are running VACUUM FULL as part of routine maintenance - for example, from a nightly cron job.
-- Craig Ringer Tech-related writing at http://soapyfrogs.blogspot.com/ -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
