On 26 September 2012 18:38, FFW_Rude <FFW_Rude@xxxxxxxxxxx> wrote: > root@testBI:/etc/postgresql/9.1/main# hdparm -tT /dev/sda > Timing cached reads: 892 MB in 2.01 seconds = 444.42 MB/sec > Timing buffered disk reads: 190 MB in 3.02 seconds = 62.90 MB/sec It's OK for single HDD. > Is fsync off by default ? I have > #fsync = on (so it's off right ?). Disable fsync for pgbench temporarily. > pgbench is not found on my server. Do i have to apt-get install pgbench ? Install the postgresql-contrib deb: http://pkgs.org/download/postgresql-contrib # sudo apt-get update # sudo apt-get install postgresql-contrib -- With best regards, Nikolay -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
