On 04/26/2012 12:49 PM, Craig James wrote:
An update to our system means I'm going to be rewriting every row of
some large tables (20 million rows by 15 columns). In a situation
like this, can auto-vacuum take care of it, or should I plan on
vacuum-full/reindex to clean up?
If you want to reclaim the space, a vacuum-full/reindex will do it. But
you are probably better off using cluster. Way faster and you get new
indexes as a by-product. Both methods require an exclusive lock on the
table. If you can't afford the downtime, check out pg_reorg
(http://pgfoundry.org/projects/reorg/)
Cheers,
Steve
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
