Re: Benchmarking a large server

Поиск
Список
Период
Сортировка
От Jeff
Тема Re: Benchmarking a large server
Дата
Msg-id 413F1B3A-F4B0-4CE9-B672-7515D607CF15@torgo.978.org
обсуждение исходный текст
Ответ на Re: Benchmarking a large server  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-performance
On May 9, 2011, at 4:50 PM, Merlin Moncure wrote:
>
> hm, if it was me, I'd write a small C program that just jumped
> directly on the device around and did random writes assuming it wasn't
> formatted.  For sequential read, just flush caches and dd the device
> to /dev/null.  Probably someone will suggest better tools though.
>
> merlin
>

<shameless plug>
http://pgfoundry.org/projects/pgiosim

it is a small program we use to beat the [bad word] out of io systems.
it randomly seeks, does an 8kB read, optionally writes it out (and
optionally fsyncing) and reports how fast it is going (you need to
watch iostat output as well so you can see actual physical tps without
hte OS cache interfering).

It goes through regular read & write calls like PG (I didn't want to
bother with junk like o_direct & friends).

it is also now multithreaded so you can fire up a bunch of random read
threads (rather than firing up a bunch of pgiosims in parallel) and
see how things scale up.


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




В списке pgsql-performance по дате отправления:

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: Postgres refusing to use >1 core
Следующее
От: Cédric Villemain
Дата:
Сообщение: Re: Benchmarking a large server