Re: : Create table taking time

[Venkat Balaji <venkat.balaji@xxxxxxxx>]

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.balaji@xxxxxxxx> 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 <mmoncure@xxxxxxxxx> wrote:

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