Skip site navigation (1) Skip section navigation (2)

Re: Performance issue with 8.2.3 - "C" application

From: Karl Denninger <karl(at)denninger(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Merlin Moncure <mmoncure(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance issue with 8.2.3 - "C" application
Date: 2007-07-25 21:01:28
Message-ID: 46A7BA28.5030203@denninger.net (view raw or flat)
Thread:
Lists: pgsql-performance
Looks like that was the problem - got a day under the belt now with the 
8.2.4 rev and all is back to normal.

Karl Denninger (karl(at)denninger(dot)net)
http://www.denninger.net




Karl Denninger wrote:
> Aha!
>
> BIG difference.  I won't know for sure until the biz day tomorrow but 
> the "first blush" look is that it makes a HUGE difference in system 
> load, and I no longer have the stats collector process on the top of 
> the "top" list......
>
> Karl Denninger (karl(at)denninger(dot)net)
> http://www.denninger.net
>
>
>
>
> Tom Lane wrote:
>> Karl Denninger <karl(at)denninger(dot)net> writes:
>>  
>>> Hmmmmm..... now that's interesting.  Stats collector IS accumulating 
>>> quite a bit of runtime..... me thinks its time to go grab 8.2.4.
>>>     
>>
>> I think Merlin might have nailed it --- the "stats collector bug" is
>> that it tries to write out the stats file way more often than it
>> should.  So any excessive userland CPU time you see is just the tip
>> of the iceberg compared to the system and I/O costs incurred.
>>
>>             regards, tom lane
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 1: if posting/reading through Usenet, please send an appropriate
>>        subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>>        message can get through to the mailing list cleanly
>>
>>
>> %SPAMBLOCK-SYS: Matched [hub.org+], message ok
>>   
>
>
> %SPAMBLOCK-SYS: Matched [(at)postgresql(dot)org+], message ok
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
>
> %SPAMBLOCK-SYS: Matched [hub.org+], message ok


%SPAMBLOCK-SYS: Matched [(at)postgresql(dot)org+], message ok

In response to

pgsql-performance by date

Next:From: Jignesh K. ShahDate: 2007-07-25 22:58:53
Subject: Re: User concurrency thresholding: where do I look?
Previous:From: Alan HodgsonDate: 2007-07-25 20:55:13
Subject: Re: Insert Statements Hanging

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group