[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-performance
Subject:    Re: [PERFORM] : Create table taking time
From:       Venkat Balaji <venkat.balaji () verse ! in>
Date:       2011-09-30 11:32:51
Message-ID: CAFrxt0jZtAqvoC5OtOucX+nuberJxobnAxt2Hi0WrxyvB4jPZg () mail ! gmail ! com
[Download RAW message or body]

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@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 <mmoncure@gmail.com>wrote:
>
>> On Wed, Sep 28, 2011 at 12:06 PM, 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 ?
>>
>> 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
>>
>
>

[Attachment #3 (text/html)]

CPU load was hitting 100% constantly with high IOs.<div><br></div><div>We tuned some \
queries to decrease the CPU usage and everything is normal \
now.</div><div><br></div><div>Thanks</div><div>VB</div><div><br><div \
class="gmail_quote"> On Fri, Sep 30, 2011 at 10:52 AM, Venkat Balaji <span \
dir="ltr">&lt;<a href="mailto:venkat.balaji@verse.in">venkat.balaji@verse.in</a>&gt;</span> \
wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px \
#ccc solid;padding-left:1ex;"> I did not calculate the IO behavior of the \
server.<div><br></div><div>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.</div>

<div><br></div><div>Thanks</div><div>VB</div><div><div></div><div \
class="h5"><div><br></div><div><br><br><div class="gmail_quote">On Thu, Sep 29, 2011 \
at 10:22 PM, Merlin Moncure <span dir="ltr">&lt;<a href="mailto:mmoncure@gmail.com" \
target="_blank">mmoncure@gmail.com</a>&gt;</span> wrote:<br>

<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div>On Wed, Sep 28, 2011 at 12:06 PM, Venkat Balaji &lt;<a \
href="mailto:venkat.balaji@verse.in" target="_blank">venkat.balaji@verse.in</a>&gt; \
wrote:<br>


&gt; Hello Everyone,<br>
&gt; I am back with an issue (likely).<br>
&gt; I am trying to create a table in our production database, and is taking 5<br>
&gt; seconds.<br>
&gt; We have executed VACUUM FULL and yet to run ANALYZE. Can i expect the CREATE<br>
&gt; TABLE to be faster after ANALYZE finishes ?<br>
&gt; Or is there anything serious ?<br>
<br>
</div>just ruling out something obvious -- this is vanilla create table, not<br>
CREATE TABLE AS SELECT...?<br>
<br>
also, what&#39;s i/o wait -- are you sure your not i/o bound and waiting<br>
on transaction commit?<br>
<font color="#888888"><br>
merlin<br>
</font></blockquote></div><br></div>
</div></div></blockquote></div><br></div>



[prev in list] [next in list] [prev in thread] [next in thread]