Re: RAID 10 Benchmark with different I/O schedulers (was: Performance increase with elevator=deadline)

From: Greg Smith <gsmith(at)gregsmith(dot)com>
To: Craig James <craig_james(at)emolecules(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: RAID 10 Benchmark with different I/O schedulers (was: Performance increase with elevator=deadline)
Date: 2008-05-06 03:59:30
Message-ID: Pine.GSO.4.64.0805052354120.3752@westnet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, 5 May 2008, Craig James wrote:

> pgbench -i -s 20 -U test

That's way too low to expect you'll see a difference in I/O schedulers.
A scale of 20 is giving you a 320MB database, you can fit the whole thing
in RAM and almost all of it on your controller cache. What's there to
schedule? You're just moving between buffers that are generally large
enough to hold most of what they need.

> pgbench -c 10 -t 50000 -v -U test

This is OK, because when you increase the size you're not going to be
pushing 3500 TPS anymore and this test will take quite a while.

--
* Greg Smith gsmith(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Gregory Williamson 2008-05-06 04:08:35 Re: need to speed up query
Previous Message Scott Marlowe 2008-05-06 03:27:03 Re: need to speed up query