Re: : Create table taking time

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(dot)balaji(at)verse(dot)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 <mmoncure(at)gmail(dot)com>wrote:
>
>> On Wed, Sep 28, 2011 at 12:06 PM, Venkat Balaji <venkat(dot)balaji(at)verse(dot)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
>>
>
>