On May 5, 2008, at 7:33 PM, Craig James wrote:

> I had the opportunity to do more testing on another new server to
> see whether the kernel's I/O scheduling makes any difference.
> Conclusion: On a battery-backed RAID 10 system, the kernel's I/O
> scheduling algorithm has no effect. This makes sense, since a
> battery-backed cache will supercede any I/O rescheduling that the
> kernel tries to do.
>

this goes against my real world experience here.

> pgbench -i -s 20 -U test
> pgbench -c 10 -t 50000 -v -U test
>

You should use a sample size of 2x ram to get a more realistic number,
or try out my pgiosim tool on pgfoundry which "sort of" simulates an
index scan. I posted numbers from that a month or two ago here.


--
Jeff Trout <jeff@jefftrout.com>
http://www.stuarthamm.net/
http://www.dellsmartexitin.com/




--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance