CPU load was hitting 100% constantly with high IOs. We tuned some queries to decrease the CPU usage and everything is normal now.
Thanks VB On Fri, Sep 30, 2011 at 10:52 AM, Venkat Balaji <venkat.bal...@verse.in>wrote: > 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 >> > >
