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

Re: freebsd + postgresql 8.3.3 = 100% of cpu usage on stats collector?

From: Bill Moran <wmoran(at)collaborativefusion(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: depesz(at)depesz(dot)com, pgsql-general(at)postgresql(dot)org
Subject: Re: freebsd + postgresql 8.3.3 = 100% of cpu usage on stats collector?
Date: 2008-06-27 22:37:45
Message-ID: 20080627183745.510e78d7.wmoran@collaborativefusion.com (view raw or flat)
Thread:
Lists: pgsql-general
On Fri, 27 Jun 2008 18:04:19 -0400
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> hubert depesz lubaczewski <depesz(at)depesz(dot)com> writes:
> > friend asked me to setup replication on their machines, and i noticed
> > that one of cpus (2 quad xeons) is used to 100%:
> > pgsql  58241 99.0  0.2 22456  7432  ??  Rs   Thu10AM 1530:35.93 postgres: stats collector process    (postgres)
> 
> Hmm, we had some problems with the stats collector going nuts a couple
> of versions ago; maybe you've found another way to trigger that.
> Anything unusual about this DB (lots of tables, for instance)?
> Can you try strace and/or gdb to figure out what the collector is doing?

Just in case you're not a FreeBSD expert, it's ktrace on FreeBSD.  strace
is the Linux equivalent.

-- 
Bill Moran <wmoran(at)collaborativefusion(dot)com>

In response to

Responses

pgsql-general by date

Next:From: Bob DuffeyDate: 2008-06-28 04:26:37
Subject: query planner weirdness?
Previous:From: Tom LaneDate: 2008-06-27 22:04:19
Subject: Re: freebsd + postgresql 8.3.3 = 100% of cpu usage on stats collector?

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