On 13/11/2009 2:29 PM, Dave Crooke wrote: > Beware that VACUUM FULL locks an entire table at a time :-)
... and often bloats its indexes horribly. Use CLUSTER instead if you need to chop a table that's massively bloated down to size; it'll be much faster, and shouldn't leave the indexes in a mess. I increasingly wonder what the purpose of VACUUM FULL in its current form is. -- Craig Ringer -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
