From: Laszlo Nagy <gandalf@shopzeus.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
To: pgsql-admin@postgresql.org
Subject: Re: rebellious postgres process
Date: Tue, 04 Nov 2008 16:40:30 +0100
Message-ID: <49106CEE.7020204@shopzeus.com> (raw)
In-Reply-To: <16117.1225804625@sss.pgh.pa.us>
References: <490FFCF4.2050500@shopzeus.com>
<16117.1225804625@sss.pgh.pa.us>
Tom Lane wrote:
> Laszlo Nagy <gandalf@shopzeus.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: gandalf@shopzeus.com, tgl@sss.pgh.pa.us
Subject: Re: rebellious postgres process
In-Reply-To: <49106CEE.7020204@shopzeus.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox