Re: 100% of CPU utilization postgres process

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Hashimoto Yuya <hill_climb(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: 100% of CPU utilization postgres process
Date: 2010-01-25 04:35:35
Message-ID: 183.1264394135@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hashimoto Yuya <hill_climb(at)hotmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Hashimoto Yuya 2010-01-25 05:26:18 Re: 100% of CPU utilization postgres process
Previous Message Steeles 2010-01-25 04:32:49 Postgresql HA on MSCS over VMWARE