Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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: pgbench.7.4CVSHEAD.24.20
Description: text/plain (2.4 KB)
Attachment: pgbench.7.4CVSHEAD.2.6.0-test4
Description: text/plain (2.4 KB)

Responses

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group