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
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)
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)
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)
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to