Thanks,
> How large is $PGDATA/global/pgstat.stat ?
Unfortunately, the size of pgstat.stat was not taken when the CPU utilization of the postgress process reached nearly 100%...
> 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.
Does it mean that CPU usage rate of stats collector process could possiblly reach 100% unless the postgres is updated to the version 8.4.x, instead of 8.3.x? (So far I'm planning to update the postgres to the version 8.3.9)
Regards,
【節約！】インターネット代、見直しませんか？
月額1,480円で快適ブロードバンド