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
-- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
