Re: pgbench gaussian/exponential docs improvements

From: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
To: Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>
Cc: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pgbench gaussian/exponential docs improvements
Date: 2015-11-05 15:36:40
Message-ID: alpine.DEB.2.10.1511051631580.29177@sto
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


I've done some work on the documentation as part of adding functions to
pgbench expression. You may have a look at:

http://www.postgresql.org/message-id/alpine.DEB.2.10.1511051256500.29177@sto

>> [...]
>> CDF2(x) = PHI(2.0 * threshold * ...) / (2.0 * PHI(threshold) - 1.0)
>>
>> and then the probability of "i" is
>>
>> P(X=i) = CDF2(i+0.5) - CDF2(i-0.5)
>
> I agree that defining the shifted/scaled CDF and using it afterwards looks
> cleaner.

After some more thoughts, ISTM that this is not exactly a CFD because of
the truncations, so I just named it "f" to be on the safe side.

--
Fabien.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2015-11-05 15:39:09 Re: BUG #13755: pgwin32_is_service not checking if SECURITY_SERVICE_SID is disabled
Previous Message Fujii Masao 2015-11-05 15:26:44 Re: Some bugs in psql_complete of psql