Re: gaussian distribution pgbench - Mailing list pgsql-hackers

From Mitsumasa KONDO
Subject Re: gaussian distribution pgbench
Date
Msg-id CADupcHUOnrhG2+yxBMUWJGDrFmg=-+tJSK-_FbPG-W+=wNbsKQ@mail.gmail.com
Whole thread Raw
In response to Re: gaussian distribution pgbench  (KONDO Mitsumasa <kondo.mitsumasa@lab.ntt.co.jp>)
Responses Re: gaussian distribution pgbench  (Fabien COELHO <coelho@cri.ensmp.fr>)
List pgsql-hackers
I add exponential distribution random generator (and little bit refactoring:) ).
I use inverse transform method to create its distribution.  It's very simple method that is
created by - log (rand()). We can control slope of distribution using threshold parameter.
It is same as gaussian threshold.

usage example
  pgbench --exponential=NUM -S

Attached graph is created with exponential threshold = 5. We can see exponential
distribution in the graphs. It supports -S, -N options and custom script. So we set
"¥setexponential [var] [min] [max] [threshold]" in a transaction pattern file, 
it appear distribution we want. 

We have no time to fix its very much... But I think almost part of patch have been completed.

Regards,
--
Mitsumasa KONDO
NTT Open Source Software Center
Attachment

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: walsender can ignore send failures in WalSndLoop
Next
From: Andres Freund
Date:
Subject: walsender doesn't send keepalives when writes are pending