We had performed VACUUM FULL and ANALYZE on the whole database. Yes, the CPU is ticking at 99-100% when i see the top command.
But, we have 8 CPUs with 6 cores each. Thanks VB On Thu, Sep 29, 2011 at 12:44 AM, Scott Marlowe <scott.marl...@gmail.com>wrote: > On Wed, Sep 28, 2011 at 11:06 AM, 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 ? > > Please share your thoughts. > > Are your system tables heavily bloated? >
