I did not calculate the IO behavior of the server. What i noticed for the logs is that, the checkpoints are occurring too frequently each checkpoint is taking up to minimum 80 - 200+ seconds to complete write and checkpoint sync is taking 80 - 200+ seconds to sync, which is i believe IO intensive.
Thanks VB On Thu, Sep 29, 2011 at 10:22 PM, Merlin Moncure <mmonc...@gmail.com> wrote: > On Wed, Sep 28, 2011 at 12:06 PM, Venkat Balaji <venkat.bal...@verse.in> > 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 >
