Postgres Pro
Downloads
Home   >   mailing lists

Re: : Create table taking time - Mailing list pgsql-performance

From Venkat Balaji
Subject Re: : Create table taking time
Date
Msg-id CAFrxt0joAz8J2wYfj_Jsxmq=qjpLJckZU8bvskDzB+5hp2_nbg@mail.gmail.com
Whole thread Raw
In response to Re: : Create table taking time  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: : Create table taking time
List pgsql-performance
Tree view
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.marlowe@gmail.com> wrote:
On Wed, Sep 28, 2011 at 11:06 AM, Venkat Balaji <venkat.balaji@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?

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: : Create table taking time
Next
From: Numael Vacca Duran
Date:
Subject: Select se bloquea