Re: filesystems benchmark

Поиск
Список
Период
Сортировка
От Greg Smith
Тема Re: filesystems benchmark
Дата
Msg-id Pine.GSO.4.64.0812151218080.7153@westnet.com
обсуждение исходный текст
Ответ на filesystems benchmark  (Adrian Moisey <adrian@careerjunction.co.za>)
Список pgsql-performance
On Mon, 15 Dec 2008, Adrian Moisey wrote:

> I'm trying to compare different filesystems for postgres using pgbench.  The
> problem I've seen is that my IO wait is very very low.  Is there a way I can
> get pgbench to do more to push that up a little?

Increase the database scale until the wait is what you expect.  See
http://www.westnet.com/~gsmith/gregsmith/content/postgresql/pgbench-scaling.htm
for details.

The latest filesystem performance comparison I'm aware of is at
http://www.baconandtech.com/files/filesystem_io.pdf

You might also take a look at that to make sure you're not re-mapping
territory that's already been explored.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

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

Предыдущее
От: "Vladimir Sitnikov"
Дата:
Сообщение: Re: filesystems benchmark
Следующее
От: "Jaime Casanova"
Дата:
Сообщение: measure database contention