Horton

Re: [WIP] Zipfian distribution in pgbench

Alik Khilazhev <a.khilazhev@postgrespro.ru>

View thread View on postgr.es
From: Alik Khilazhev <a.khilazhev@postgrespro.ru>
To: Peter Geoghegan <pg@bowt.ie>
Cc: Alvaro Herrera <alvherre@2ndquadrant.com>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2017-07-13T11:38:26Z
Lists: pgsql-hackers 
> On 13 Jul 2017, at 00:20, Peter Geoghegan <pg@bowt.ie> wrote:
> 
> Actually, I mean that I wonder how much of a difference it would make
> if this entire block was commented out within _bt_doinsert():
> 
> if (checkUnique != UNIQUE_CHECK_NO)
> {
>    …
> }
> 
I am attaching results of test for 32 and 128 clients for original and patched(_bt_doinsert) variants.
— 
Thanks and Regards,
Alik Khilazhev
Postgres Professional:
http://www.postgrespro.com <http://www.postgrespro.com/>
The Russian Postgres Company

Commits

  1. Add approximated Zipfian-distributed random generator to pgbench.