Hi,
Rude - Last Territory
Date: Wed, 26 Sep 2012 08:34:06 -0700
From: [hidden email]
To: [hidden email]
Subject: Re: Same query doing slow then quick
root@testBI:/etc/postgresql/9.1/main# hdparm -tT /dev/sda
/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
Is fsync off by default ? I have
#fsync = on (so it's off right ?).
pgbench is not found on my server. Do i have to apt-get install pgbench ?
Rude - Last Territory
Ou écouter ?
Ou acheter ?
La Fnac
iTunes
Date: Wed, 26 Sep 2012 08:34:06 -0700
From: [hidden email]
To: [hidden email]
Subject: 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
If you reply to this email, your message will be added to the discussion below:
http://postgresql.1045698.n5.nabble.com/Same-query-doing-slow-then-quick-tp5725486p5725533.html
View this message in context: RE: Same query doing slow then quick
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
