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

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 (view raw or flat)
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

pgsql-performance by date

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

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