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

Поиск
Список
Период
Сортировка
От Mike Broers
Тема Re: driving postgres to achieve benchmark results similar to bonnie++
Дата
Msg-id CAB9893iitE_qKK7Bvmo8a-N3QLh=r3=KOHFhMVp5HDpxRJh4Sg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: driving postgres to achieve benchmark results similar to bonnie++  (Kevin Grittner <kgrittn@gmail.com>)
Ответы Re: driving postgres to achieve benchmark results similar to bonnie++
Список pgsql-admin
I've set this parameter to 256 to test, still getting the same results.  The only way I reliably see a spike in IO at all is on the pgbench initialization (still peaking around 110MB/sec writes), so I'm thinking about playing around with that or duplicating its approach with larger rows and running it from multiple sessions in different initialization databases on the same volume.  If I cant push it further using that technique then there must be some dumb bottleneck in config I am overlooking.  



On Tue, May 10, 2016 at 3:24 PM, Kevin Grittner <kgrittn@gmail.com> wrote:
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 по дате отправления:

Предыдущее
От: Ondřej Světlík
Дата:
Сообщение: Re: Autovacuum of pg_database
Следующее
От: Mike Broers
Дата:
Сообщение: Re: driving postgres to achieve benchmark results similar to bonnie++