I did some benchmarking using pgbench and postgresql CVS head, compiled
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.
pgsql-performance by date
|Next:||From: Jeff||Date: 2003-08-27 15:51:29|
|Subject: Re: Sun vs a P2. Interesting results.|
|Previous:||From: scott.marlowe||Date: 2003-08-27 15:17:42|
|Subject: Re: Hardware recommendations to scale to silly load|