Hi, FFW_Rude 1. Benchmark the device with your PostgreSQL DB:
# hdparm -tT /dev/sda /dev/sda: Timing cached reads: 6604 MB in 2.00 seconds = 3303.03 MB/sec Timing buffered disk reads: 1316 MB in 3.00 seconds = 438.18 MB/sec 2. Benchmark your PostgreSQL with pgbench: Set "fsync = off" on /var/lib/pgsql/data/postgresql.conf # /etc/init.d/postgresql restart # su - postgres $ psql # create database pgbench; # \q # pgbench -i pgbench && pgbench -c 10 -t 10000 pgbench tps = 5670.635648 (including connections establishing) tps = 5673.630345 (excluding connections establishing)[/code] Set "fsync = on" on /var/lib/pgsql/data/postgresql.conf # /etc/init.d/postgresql restart -- With best regards, Nikolay
