On Wed, Sep 28, 2011 at 12:06 PM, Venkat Balaji <venkat.balaji@xxxxxxxx> wrote: > Hello Everyone, > I am back with an issue (likely). > I am trying to create a table in our production database, and is taking 5 > seconds. > We have executed VACUUM FULL and yet to run ANALYZE. Can i expect the CREATE > TABLE to be faster after ANALYZE finishes ? > Or is there anything serious ? just ruling out something obvious -- this is vanilla create table, not CREATE TABLE AS SELECT...? also, what's i/o wait -- are you sure your not i/o bound and waiting on transaction commit? merlin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
