Re: [HACKERS] pgbench: faster version of tpcb-like transaction

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: [HACKERS] pgbench: faster version of tpcb-like transaction
Дата
Msg-id CAH2-Wz=9mvi8Ni5m7L3Q-rkUgYP9ypyqoMSGiMYR9JsO+boo+g@mail.gmail.com
обсуждение исходный текст
Ответ на [HACKERS] pgbench: faster version of tpcb-like transaction  (Jeff Janes <jeff.janes@gmail.com>)
Ответы Re: [HACKERS] pgbench: faster version of tpcb-like transaction  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-hackers
Дерево обсуждения 
On Sat, Aug 26, 2017 at 3:53 PM, Jeff Janes <jeff.janes@gmail.com> wrote:
> I get nearly a 3 fold speed up using the new transaction, from 9184 to 26383
> TPS, on 8 CPU machine using scale 50 and:
>
> PGOPTIONS="-c synchronous_commit=off" pgbench -c32 -j32 -T60 -b tpcb-like

What about with "-M prepared"? I think that most of us use that
setting already, especially with CPU-bound workloads.


-- 
Peter Geoghegan

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

Предыдущее
От: Michael Malis
Дата:
Сообщение: [HACKERS] Poor cost estimate with interaction between table correlation andpartial indexes
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: [HACKERS] pgbench: faster version of tpcb-like transaction