Re: Performance issue with 8.2.3 - "C" application

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Karl Denninger <karl(at)denninger(dot)net>
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:25:06
Message-ID: 122.1185333906@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Karl Denninger 2007-07-25 03:35:41 Re: Performance issue with 8.2.3 - "C" application
Previous Message Karl Denninger 2007-07-25 03:16:16 Re: Performance issue with 8.2.3 - "C" application