Re: "VACUUM FULL ANALYZE" vs. Autovacuum Contention

On 07/08/2011 12:46 PM, D C wrote:
> That said, it sounds like if we switched to daily "trucates" of each
> table (they can be purged entirely each day) rather than "delete
> froms", then there truly would not be any reason to use "vacuum
> full". Does that sound plausible?

That's exactly right. If you can re-arrange this data to be truncated
instead of deleted, this entire problem should go away. There is also a
nice optimization you should know about; if you do this:

BEGIN;
TRUNCATE t;
COPY t FROM ...
COMMIT;

In single-node systems (no standby slave), this can work much faster
than a normal load. It's able to skip the pg_xlog WAL writes in this
situation.

--
Greg Smith 2ndQuadrant US greg(at)2ndQuadrant(dot)com Baltimore, MD
Comprehensive and Customized PostgreSQL Training Classes:
http://www.2ndquadrant.us/postgresql-training/