Re: Using IOZone to simulate DB access patterns

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Using IOZone to simulate DB access patterns
Дата
Msg-id 49DF8277.4050801@agliodbs.com
обсуждение исходный текст
Ответ на Re: Using IOZone to simulate DB access patterns  (Scott Carey <scott@richrelevance.com>)
Ответы Re: Using IOZone to simulate DB access patterns  (Scott Carey <scott@richrelevance.com>)
Список pgsql-performance
Scott,

> FIO with profiles such as the below samples are easy to set up, and they can
> be mix/matched to test what happens with mixed read/write seq/rand -- with
> surprising and useful tuning results.  Forcing a cache flush or sync before
> or after a run is trivial.  Changing to asynchronous I/O, direct I/O, or
> other forms is trivial.  The output result formatting is very useful as
> well.

FIO?  Link?


--
Josh Berkus
PostgreSQL Experts Inc.
www.pgexperts.com

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Shouldn't the planner have a higher cost for reverse index scans?
Следующее
От: Scott Carey
Дата:
Сообщение: Re: Using IOZone to simulate DB access patterns