Postgres Pro
Downloads
Home   >   mailing lists

Re: 100% of CPU utilization postgres process - Mailing list pgsql-general

From Tom Lane
Subject Re: 100% of CPU utilization postgres process
Date
Msg-id 183.1264394135@sss.pgh.pa.us
Whole thread Raw
In response to 100% of CPU utilization postgres process  (Hashimoto Yuya <hill_climb@hotmail.com>)
Responses Re: 100% of CPU utilization postgres process  (Hashimoto Yuya <hill_climb@hotmail.com>)
List pgsql-general
Tree view 
Hashimoto Yuya <hill_climb@hotmail.com> writes:
> [ lots of time spent by stats collector process ]

How large is $PGDATA/global/pgstat.stat ?

If it's very large (many MB), try doing pg_stats_reset().  If that makes
the stats collector CPU usage drop, consider an update to PG 8.4.x,
which is more efficient at dealing with large stats files.

            regards, tom lane

pgsql-general by date:

Previous
From: Steeles
Date:
Subject: Postgresql HA on MSCS over VMWARE
Next
From: Hashimoto Yuya
Date:
Subject: Re: 100% of CPU utilization postgres process