Re: driving postgres to achieve benchmark results similar to bonnie++

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: driving postgres to achieve benchmark results similar to bonnie++
Дата
Msg-id CACjxUsOxeLuSJ8+DKuqqtxe8Z3mKDBjQrYnkdZ4za9zzaV+dYg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: driving postgres to achieve benchmark results similar to bonnie++  (Mike Broers <mbroers@gmail.com>)
Ответы Re: driving postgres to achieve benchmark results similar to bonnie++
Список pgsql-admin
Дерево обсуждения 
On Tue, May 10, 2016 at 2:02 PM, Mike Broers <mbroers@gmail.com> wrote:

> If someone has an idea for how to set up pgbench to
> really push the io to prove out ssd potential, or a different
> script/approach that would be awesome.

You might want to play with some large effective_io_concurrency
settings, starting around 256.

http://www.postgresql.org/message-id/CAHyXU0yiVvfQAnR9cyH=HWh1WbLRsioe=mzRJTHwtr=2azsTdQ@mail.gmail.com

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

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

Предыдущее
От: "Campbell, Lance"
Дата:
Сообщение: Memory and Swap
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Major Version Upgradation in Replication Environment