Re: Same query doing slow then quick

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