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

Re: rebellious postgres process

From: Laszlo Nagy <gandalf(at)shopzeus(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-admin(at)postgresql(dot)org
Subject: Re: rebellious postgres process
Date: 2008-11-04 15:40:30
Message-ID: 49106CEE.7020204@shopzeus.com (view raw or flat)
Thread:
Lists: pgsql-admin
Tom Lane wrote:
> 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.
>   
My version is 8.3.3. Complied from FreeBSD ports.  I just updated my 
ports tree and that is the most up to date officially (sup)ported version.

The process is still running:


  PID USERNAME       THR PRI NICE   SIZE    RES STATE  C   TIME   WCPU 
COMMAND
  904 pgsql            1 105    0 22396K  5428K CPU1   1 856:13 99.02% 
postgres

> Do you have a whole lot of tables in this database?  
One database has 140 tables, the other has 62. (There are two other 
database instances but they are rarely used.)
> (Or even more directly: how large is $PGDATA/global/pgstat.stat ?)
>   
-rw-------  1 pgsql  pgsql  54536 Nov  3 20:11 pgstat.stat

Thanks,

    Laszlo



In response to

Responses

pgsql-admin by date

Next:From: Laszlo NagyDate: 2008-11-04 15:48:37
Subject: Re: rebellious postgres process
Previous:From: Tom LaneDate: 2008-11-04 14:49:37
Subject: Re: Installation Error of postgresql-8.1.5 with perl.

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