Re: [HACKERS] [WIP] Zipfian distribution in pgbench

Поиск
Список
Период
Сортировка
Искать
От
Fabien COELHO
Тема
Re: [HACKERS] [WIP] Zipfian distribution in pgbench
Дата
Msg-id
alpine.DEB.2.20.1707171247270.9472@lancre
Ответ на
Список
Дерево обсуждения
[HACKERS] [WIP] Zipfian distribution in pgbench Alik Khilazhev <a.khilazhev@postgrespro.ru>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Alik Khilazhev <a.khilazhev@postgrespro.ru>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Alik Khilazhev <a.khilazhev@postgrespro.ru>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Alik Khilazhev <a.khilazhev@postgrespro.ru>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Alik Khilazhev <a.khilazhev@postgrespro.ru>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Alik Khilazhev <a.khilazhev@postgrespro.ru>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Alik Khilazhev <a.khilazhev@postgrespro.ru>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Alik Khilazhev <a.khilazhev@postgrespro.ru>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Alik Khilazhev <a.khilazhev@postgrespro.ru>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Alik Khilazhev <a.khilazhev@postgrespro.ru>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Peter Geoghegan <pg@bowt.ie>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Alik Khilazhev <a.khilazhev@postgrespro.ru>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Alik Khilazhev <a.khilazhev@postgrespro.ru>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Alik Khilazhev <a.khilazhev@postgrespro.ru>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Alik Khilazhev <a.khilazhev@postgrespro.ru>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Daniel Gustafsson <daniel@yesql.se>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Alik Khilazhev <a.khilazhev@postgrespro.ru>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Alik Khilazhev <a.khilazhev@postgrespro.ru>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Alik Khilazhev <a.khilazhev@postgrespro.ru>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Teodor Sigaev <teodor@sigaev.ru>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Alik Khilazhev <a.khilazhev@postgrespro.ru>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Peter Geoghegan <pg@bowt.ie>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Peter Geoghegan <pg@bowt.ie>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Peter Geoghegan <pg@bowt.ie>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Peter Geoghegan <pg@bowt.ie>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Alik Khilazhev <a.khilazhev@postgrespro.ru>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Peter Geoghegan <pg@bowt.ie>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Peter Geoghegan <pg@bowt.ie>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Peter Geoghegan <pg@bowt.ie>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Alik Khilazhev <a.khilazhev@postgrespro.ru>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Peter Geoghegan <pg@bowt.ie>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Peter Geoghegan <pg@bowt.ie>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Peter Geoghegan <pg@bowt.ie>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Alik Khilazhev <a.khilazhev@postgrespro.ru>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Peter Geoghegan <pg@bowt.ie>
Re: [HACKERS] [WIP] Zipfian distribution in pgbench Peter Geoghegan <pg@bowt.ie>

>> 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,

Ok. So this is similar to what I got.

Is this bias expected from the drawing method, say because it is 
approximated and the approximation is weak at some points, or is there an 
issue with its implementation, says some shift which gets smoothed down 
for higher indexes?

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

I'll look into that.

-- 
Fabien.


В списке pgsql-hackers по дате отправления
От: Christoph Berg
Дата:
От: Alik Khilazhev
Дата:
FAQ