Re: [WIP] Zipfian distribution in pgbench

From: Alik Khilazhev <a(dot)khilazhev(at)postgrespro(dot)ru>
To: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
Cc: PostgreSQL Developers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [WIP] Zipfian distribution in pgbench
Date: 2017-07-17 10:34:15
Message-ID: AEF3B12A-D246-41FC-9A6F-15815E38F525@postgrespro.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello Fabien,

> On 14 Jul 2017, at 17:51, Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> wrote:
>
> Ok, so you did not get the large bias for i=3. Strange.

I got large bias for i=3 and theta > 1 even with a million outcomes, but for theta < 1 (I have tested on theta = 0.1 and 0.3) it showed quite good results.

I am attaching patch v3. Among other things I fixed small typo in description of random_exponential function in pgbench.sgml file.

—
Thanks and Regards,
Alik Khilazhev
Postgres Professional:
http://www.postgrespro.com <http://www.postgrespro.com/>
The Russian Postgres Company

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Neha Sharma 2017-07-17 10:46:34 pg_restore failed for foreign key constraint
Previous Message Alexander Korotkov 2017-07-17 10:22:40 Re: Pluggable storage