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

Re: rebellious postgres process

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Laszlo Nagy <gandalf(at)shopzeus(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: rebellious postgres process
Date: 2008-11-04 13:17:05
Message-ID: 16117.1225804625@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
Laszlo Nagy <gandalf(at)shopzeus(dot)com> writes:
> The processi is using 100% CPU for 52 hours! Here it is:

> %ps axl | grep 677
>   70   677   666 757 107  0 22396  5460 select Rs    ??  3144:50.88 
> postgres: stats collector process    (postgres)

Huh, that's weird.  We've fixed some bugs in the past that led the stats
collector to consume excessive CPU --- but that was all pre-8.3.

Do you have a whole lot of tables in this database?  (Or even more
directly: how large is $PGDATA/global/pgstat.stat ?)

			regards, tom lane

In response to

Responses

pgsql-admin by date

Next:From: praveenDate: 2008-11-04 14:20:49
Subject: Installation Error of postgresql-8.1.5 with perl.
Previous:From: Sathish DuraiswamyDate: 2008-11-04 13:08:39
Subject: Re: [GENERAL] epqa; postgres performance optimizer support tool; opensource.

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