> We have executed VACUUM FULL and yet to run ANALYZE. Can i expect the CREATE > TABLE to be faster after ANALYZE finishes ?
The only way CREATE TABLE would be affected by VACUUM ANALYZE running is if you're saturating either your CPU or your disk 100%. Which you may be, on a low-end system. -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
