Re: gaussian distribution pgbench -- splits v4 - Mailing list pgsql-hackers

From Mitsumasa KONDO
Subject Re: gaussian distribution pgbench -- splits v4
Date
Msg-id CADupcHUrKZRfZifVG-fc-2mEtouMh0QPU+aSv_Pj9Cagzy8POg@mail.gmail.com
Whole thread Raw
In response to Re: gaussian distribution pgbench -- splits v4  (Fabien COELHO <coelho@cri.ensmp.fr>)
Responses Re: gaussian distribution pgbench -- splits Bv6  (Fabien COELHO <coelho@cri.ensmp.fr>)
List pgsql-hackers
Hi,

Thank you for your grate documentation and fix working!!!
It becomes very helpful for understanding our feature. 

I add two feature in gauss_B_4.patch.

1) Add gaussianProbability() function
It is same as exponentialProbability(). And the feature is as same as before.

2) Add result of "max/min percent of the range"
It is almost same as --exponential option's result. However, max percent of the range is center of distribution
and min percent of the range is most side of distribution. 
Here is the output example,

+ pgbench_account's aid selected with a truncated gaussian distribution

+ standard deviation threshold: 5.00000

+ decile percents: 0.0% 0.1% 2.1% 13.6% 34.1% 34.1% 13.6% 2.1% 0.1% 0.0%

+ probability of max/min percent of the range: 4.0% 0.0%


And I add the explanation about this in the document.

I'm very appreciate for your works!!!


Best regards,

--

Mitsumasa KONDO 

Attachment

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: [RFC] Should smgrtruncate() avoid sending sinval message for temp relations
Next
From: Magnus Hagander
Date:
Subject: Re: 9.4 docs current as of