Re: pgbench gaussian/exponential docs improvements

Поиск
Список
Период
Сортировка
От Fabien COELHO
Тема Re: pgbench gaussian/exponential docs improvements
Дата
Msg-id alpine.DEB.2.10.1511051631580.29177@sto
обсуждение исходный текст
Ответ на Re: pgbench gaussian/exponential docs improvements  (Fabien COELHO <coelho@cri.ensmp.fr>)
Ответы Re: pgbench gaussian/exponential docs improvements
Список 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.



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Fujii Masao
Дата:
Сообщение: Re: Some bugs in psql_complete of psql
Следующее
От: Masahiko Sawada
Дата:
Сообщение: Re: Freeze avoidance of very large table.