Re: pgbench: faster version of tpcb-like transaction

From: Peter Geoghegan <pg(at)bowt(dot)ie>
To: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pgbench: faster version of tpcb-like transaction
Date: 2017-08-26 23:28:27
Message-ID: CAH2-Wz=9mvi8Ni5m7L3Q-rkUgYP9ypyqoMSGiMYR9JsO+boo+g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sat, Aug 26, 2017 at 3:53 PM, Jeff Janes <jeff(dot)janes(at)gmail(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeff Janes 2017-08-26 23:59:14 Re: pgbench: faster version of tpcb-like transaction
Previous Message Michael Malis 2017-08-26 23:20:27 Poor cost estimate with interaction between table correlation and partial indexes