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 03:35:41
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance

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)

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 [], message ok

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

In response to


pgsql-performance by date

Next:From: Nis JørgensenDate: 2007-07-25 06:17:58
Subject: Re: Performance issue with 8.2.3 - "C" application
Previous:From: Tom LaneDate: 2007-07-25 03:25:06
Subject: Re: Performance issue with 8.2.3 - "C" application

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