Comparing postgresql7.4 CVS head on linux 2.4.20 and 2.6.0-test4

From: Shridhar Daithankar <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: pgsql-performance(at)postgresql(dot)org
Subject: Comparing postgresql7.4 CVS head on linux 2.4.20 and 2.6.0-test4
Date: 2003-08-27 15:32:25
Message-ID: 200308272102.26319.shridhar_daithankar@persistent.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Content-Type Size
pgbench.7.4CVSHEAD.2.6.0-test4 text/plain 2.4 KB
pgbench.7.4CVSHEAD.24.20 text/plain 2.4 KB

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jeff 2003-08-27 15:51:29 Re: Sun vs a P2. Interesting results.
Previous Message scott.marlowe 2003-08-27 15:17:42 Re: Hardware recommendations to scale to silly load