Re: [GENERAL] 100% of CPU utilization postgres process

2010-01-24 Thread Hashimoto Yuya
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 dr

Re: [GENERAL] 100% of CPU utilization postgres process

2010-01-24 Thread Hashimoto Yuya
> 8.3.3 is fairly old, they are up to 8.3.9 in that version. seee the > release notes for each version from 8.3.4 to 8.3.9 to see what bugs were > fixed... > http://www.postgresql.org/docs/current/static/release.html Thanks, I was planning to update the postgres to the newer version, but

[GENERAL] 100% of CPU utilization postgres process

2010-01-24 Thread Hashimoto Yuya
Hello, I observed the event that CPU utilization of the process related to postgres records almost 100% for unknown reason. It would be appreciated if any of you provide any information on this. The following line is a part of the result of "ps -auxeww". ===