pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feed From: Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
To: pgsql-performance@postgresql.org
Subject: 2.4 v/s 2.6 again.
Date: Fri, 29 Aug 2003 21:59:14 +0530
Message-ID: <200308292159.14095.shridhar_daithankar@persistent.co.in> (raw )
Hi all,
I compared 2.6 with elevator=deadline. It did bring some improvement in
performance. But still it does not beat 2.4.
Attached are three files for details.
I also ran a simple insert benchmark to insert a million record in a simple
table with a small int and a varchar(30).
Here are the results
2.6 deadline
1K/xact 299sec
10K/xact 277 sec
100K/xact 271 sec
2.6 AS
1K/xact 262sec
10K/xact Not done
100K/xact 257 sec
2.6 AS
1K/xact 252sec
10K/xact 243 sec
100K/xact 246 sec
It seems that I noted a test result wrongly. I need to do it again.
Overall 2.6 needs some real IO improvements. Of course it could do better on
multiway machine.
I guess there is no point bothering this with kernel hackers. They know this
stuff already, right.
Looking forward to next release of kernel and hope it improves things...
Shridhar
Attachments:
pgbench.7.4CVSHEAD.2.6.0-test4 (text/plain, 2.4K) download
Vacumm full done after each run.
pg_resetlog run between each server start
Scaling factor: 10
Initialization time:
real 1m42.282s
user 0m1.787s
sys 0m0.121s
Kernel 2.6.0-test4
Effective cache size 38400 (300MB)
checkpoint segments=6
1)Shared buffers 1000
pgbench -c5 -t100 test1
tps = 131.962542 (including connections establishing)
tps = 134.418358 (excluding connections establishing)
pgbench -c5 -t1000 test1
tps = 79.301493 (including connections establishing)
tps = 79.393258 (excluding connections establishing)
pgbench -c10 -t100 test1
tps = 64.917044 (including connections establishing)
tps = 65.438067 (excluding connections establishing)
pgbench -c10 -t1000 test1
tps = 66.135615 (including connections establishing)
tps = 66.193039 (excluding connections establishing)
2) Shared buffers 2000
pgbench -c5 -t100 test1
tps = 135.598994 (including connections establishing)
tps = 138.296634 (excluding connections establishing)
pgbench -c5 -t1000 test1
tps = 81.331678 (including connections establishing)
tps = 81.425369 (excluding connections establishing)
pgbench -c10 -t100 test1
tps = 116.524476 (including connections establishing)
tps = 118.388407 (excluding connections establishing)
pgbench -c10 -t1000 test1
tps = 64.659894 (including connections establishing)
tps = 64.719829 (excluding connections establishing)
3) Shared buffers 3000
pgbench -c5 -t100 test
tps = 132.489569 (including connections establishing)
tps = 135.177003 (excluding connections establishing)
pgbench -c5 -t1000 test
tps = 70.272855 (including connections establishing)
tps = 70.343452 (excluding connections establishing)
pgbench -c10 -t100 test
tps = 121.624524 (including connections establishing)
tps = 123.549086 (excluding connections establishing)
pgbench -c10 -t1000 test
tps = 64.124644 (including connections establishing)
tps = 64.183736 (excluding connections establishing)
4) noatime enabled Shared buffers 3000
pgbench -c5 -t100 test
tps = 90.850600 (including connections establishing)
tps = 92.053686 (excluding connections establishing)
pgbench -c5 -t1000 test
tps = 92.209724 (including connections establishing)
tps = 92.329682 (excluding connections establishing)
pgbench -c10 -t100 test
tps = 79.264231 (including connections establishing)
tps = 80.145448 (excluding connections establishing)
pgbench -c10 -t1000 test
tps = 70.439082 (including connections establishing)
tps = 70.506189 (excluding connections establishing)
pgbench.7.4CVSHEAD.2.6.0-test4.deadline (text/plain, 1.3K) download
Vacumm full done after each run.
pg_resetlog run between each server start
Scaling factor: 10
Initialization time:
real 1m44.512s
user 0m1.765s
sys 0m0.134s
Kernel 2.6.0-test4
Effective cache size 38400 (300MB)
checkpoint segments=6
1)Shared buffers 1000
pgbench -c5 -t100 test1
tps = 135.647884 (including connections establishing)
tps = 138.318785 (excluding connections establishing)
pgbench -c5 -t1000 test1
tps = 61.097461 (including connections establishing)
tps = 61.144720 (excluding connections establishing)
pgbench -c10 -t100 test1
tps = 121.626566 (including connections establishing)
tps = 123.517787 (excluding connections establishing)
pgbench -c10 -t1000 test1
tps = 54.618036 (including connections establishing)
tps = 54.654704 (excluding connections establishing)
2) Shared buffers 2000
pgbench -c5 -t100 test1
tps = 131.715307 (including connections establishing)
tps = 134.220729 (excluding connections establishing)
pgbench -c5 -t1000 test1
tps = 74.486274 (including connections establishing)
tps = 74.559177 (excluding connections establishing)
pgbench -c10 -t100 test1
tps = 127.431602 (including connections establishing)
tps = 129.461754 (excluding connections establishing)
pgbench -c10 -t1000 test1
tps = 51.840810 (including connections establishing)
tps = 51.875044 (excluding connections establishing)
pgbench.7.4CVSHEAD.24.20 (text/plain, 2.4K) download
Vacumm full done after each run.
pg_resetlog run between each server start
Scaling factor: 10
Initialization time:
real 1m32.551s
user 0m1.710s
sys 0m0.130s
Kernel 2.4.20
Effective cache size 38400 (300MB)
checkpoint segments=6
1)Shared buffers 1000
pgbench -c5 -t100 test1
tps = 145.504917 (including connections establishing)
tps = 147.991299 (excluding connections establishing)
pgbench -c5 -t1000 test1
tps = 70.785341 (including connections establishing)
tps = 70.849065 (excluding connections establishing)
pgbench -c10 -t100 test1
tps = 147.605267 (including connections establishing)
tps = 149.944123 (excluding connections establishing)
pgbench -c10 -t1000 test1
tps = 55.646866 (including connections establishing)
tps = 55.678399 (excluding connections establishing)
2) Shared buffers 2000
pgbench -c5 -t100 test1
tps = 140.115444 (including connections establishing)
tps = 142.441377 (excluding connections establishing)
pgbench -c5 -t1000 test1
tps = 77.015876 (including connections establishing)
tps = 77.084474 (excluding connections establishing)
pgbench -c10 -t100 test1
tps = 128.512768 (including connections establishing)
tps = 130.314689 (excluding connections establishing)
pgbench -c10 -t1000 test1
tps = 55.003077 (including connections establishing)
tps = 55.035001 (excluding connections establishing)
3) Shared buffers 3000
pgbench -c5 -t100 test1
tps = 153.142499 (including connections establishing)
tps = 156.094637 (excluding connections establishing)
pgbench -c5 -t1000 test1
tps = 81.391878 (including connections establishing)
tps = 81.472845 (excluding connections establishing)
pgbench -c10 -t100 test1
tps = 120.420876 (including connections establishing)
tps = 122.066975 (excluding connections establishing)
pgbench -c10 -t1000 test1
tps = 56.766460 (including connections establishing)
tps = 56.801117 (excluding connections establishing)
4) Shared buffers 3000, noatime
pgbench -c5 -t100 test1
tps = 140.464589 (including connections establishing)
tps = 143.152323 (excluding connections establishing)
pgbench -c5 -t1000 test1
tps = 94.718161 (including connections establishing)
tps = 94.826618 (excluding connections establishing)
pgbench -c10 -t100 test1
tps = 131.925129 (including connections establishing)
tps = 133.826403 (excluding connections establishing)
pgbench -c10 -t1000 test1
tps = 65.374006 (including connections establishing)
tps = 65.458626 (excluding connections establishing)
Message-ID: <200308292159.14095.shridhar_daithankar@persistent.co.in>
Permalink: ../200308292159.14095.shridhar_daithankar@persistent.co.in/
Also on: postgresql.org/message-id/200308292159.14095.shridhar_daithankar@persistent.co.in
copy link · copy postgr.es
reply Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: shridhar_daithankar@persistent.co.in
Subject: Re: 2.4 v/s 2.6 again.
In-Reply-To: <200308292159.14095.shridhar_daithankar@persistent.co.in>
References: <200308292159.14095.shridhar_daithankar@persistent.co.in>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox