Comparing postgresql7.4 CVS head on linux 2.4.20 and 2.6.0-test4 - Mailing list pgsql-performance

From Shridhar Daithankar
Subject Comparing postgresql7.4 CVS head on linux 2.4.20 and 2.6.0-test4
Date
Msg-id 200308272102.26319.shridhar_daithankar@persistent.co.in
Whole thread Raw
Responses Re: Comparing postgresql7.4 CVS head on linux 2.4.20 and 2.6.0-test4  (Neil Conway <neilc@samurai.com>)
List pgsql-performance
Hi all,

I did some benchmarking using pgbench and postgresql CVS head, compiled
yesterday.

The results are attached. It looks like 2.6.0-test4 does better under load but
under light load the performance isn't that great. OTOH 2.4.20 suffer major
degradation compare to 2.6. Looks like linux is also getting heavy at lower
end. Of course it isn't as bad as solaris as yet..:-)

IIRC in a kernel release note recently, it was commented that IO scheduler is
still being worked on and does not perform as much for random seeks, which
exaclty what database needs.

How does these number stack up with other platforms? Anybody with SCSI disks
out there? I doubt IDE has some role to play with this.

Comments?

 Shridhar

Attachment

pgsql-performance by date:

Previous
From: Bill Moran
Date:
Subject: Re: Hardware recommendations to scale to silly load
Next
From: "Anders K. Pedersen"
Date:
Subject: Queries sometimes take 1000 times the normal time