Linux 2.2 vs 2.4

From: Matthew Kirkwood <matthew(at)hairy(dot)beasts(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Linux 2.2 vs 2.4
Date: 2001-02-17 23:18:37
Message-ID: Pine.LNX.4.10.10102172257120.18693-100000@sphinx.mythic-beasts.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

Not sure if anyone will find this of interest, but I ran
pgbench on my main Linux box to see what sort of performance
difference might be visible between 2.2 and 2.4 kernels.

Hardware: A dual P3-450 with 384Mb of RAM and 3 SCSI disks.
The pg datafiles live in a half-gig partition on the first
one.

Software: Red Hat 6.1 plus all sort of bits and pieces.
PostgreSQL 7.1beta4 RPMs. pgbench hand-compiled from source
for same. No options changed from defaults. (I'll look at
that tomorrow -- is there anything worth changing other than
commit_delay and fsync?)

Kernels: 2.2.15 + software RAID patches, 2.4.2-pre2

With 2.2.15:
pgbench -s5 -i: 1.27.78 elapsed
pgbench -s5 -t100:
clients: TPS / TPS (excluding connection establishment)
1: 39.66 / 40.08 TPS
2: 60.77 / 61.64 TPS
4: 76.15 / 77.42
8: 90.99 / 92.73
16: 71.10 / 72.15
32: 49.20 / 49.70
1: 27.76 / 28.00
1: 27.82 / 28.03

pgbench -v -s5 -t100:
1: 30.73 / 30.98

And with 2.4.2-pre2:
pgbench -s5 -i: 1:17.46 elapsed
pgbench -s5 -t100
1: 43.57 / 44.11 TPS
2: 62.85 / 63.86 TPS
4: 87.24 / 89.08 TPS
8: 86.60 / 88.38 TPS
16: 53.22 / 53.88 TPS
32: 60.28 / 61.10 TPS
1: 35.93 / 36.33
1: 34.82 / 35.18

pgbench -v -s5 -t100:
1: 35.70 / 36.01

Overall, two things jump out at me.

Firstly, it looks like 2.4 is mixed news for heavy pgbench users
:) Low-utilisation numbers are better, but the sweet spot seems
lower and narrower.

Secondly, in both occasions after a run, performance has been
more than 20% lower. Restarting or performing a full vacuum does
not seem to help. Is there some sort of fragmentation issue
here?

Matthew.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Brent Verner 2001-02-17 23:30:12 Re: WAL and commit_delay
Previous Message Dominic J. Eidson 2001-02-17 23:05:31 Re: WAL and commit_delay