Re: 100% of CPU utilization postgres process

Hashimoto Yuya wrote:
> -Postgres version : "PostgreSQL 8.3.3 on i386-portbld-freebsd7.0,
> compiled by GCC cc (GCC) 4.2.1 20070719 [FreeBSD]"

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



> -disk configuration :
> 3 HITACHI 7,200rpm SATA disks in RAID5

raid 5 performs rather badly on database update kind of operations,
especially without a battery backed writeback cache

not saying this is your problem, but its not a real good idea. We use
raid1+0 aka raid10 for our database volumes