Re: CPU costs of random_zipfian in pgbench
От
Fabien COELHO
Тема
Re: CPU costs of random_zipfian in pgbench
Дата
Msg-id
alpine.DEB.2.21.1902221703350.4182@lancre
Ответ на
Re: CPU costs of random_zipfian in pgbench (Tomas Vondra)
Список
Дерево обсуждения
CPU costs of random_zipfian in pgbench Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: CPU costs of random_zipfian in pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: CPU costs of random_zipfian in pgbench Tom Lane <tgl@sss.pgh.pa.us>
Re: CPU costs of random_zipfian in pgbench David Fetter <david@fetter.org>
Re: CPU costs of random_zipfian in pgbench Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: CPU costs of random_zipfian in pgbench David Fetter <david@fetter.org>
Re: CPU costs of random_zipfian in pgbench Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: CPU costs of random_zipfian in pgbench Peter Geoghegan <pg@bowt.ie>
Re: CPU costs of random_zipfian in pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: CPU costs of random_zipfian in pgbench Peter Geoghegan <pg@bowt.ie>
Re: CPU costs of random_zipfian in pgbench Ants Aasma <ants.aasma@eesti.ee>
Re: CPU costs of random_zipfian in pgbench Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: CPU costs of random_zipfian in pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: CPU costs of random_zipfian in pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: CPU costs of random_zipfian in pgbench Georgios Kokolatos <gkokolatos@pm.me>
Re: CPU costs of random_zipfian in pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: CPU costs of random_zipfian in pgbench Georgios Kokolatos <gkokolatos@pm.me>
Re: CPU costs of random_zipfian in pgbench Tom Lane <tgl@sss.pgh.pa.us>
Re: CPU costs of random_zipfian in pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: CPU costs of random_zipfian in pgbench Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: CPU costs of random_zipfian in pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: CPU costs of random_zipfian in pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: CPU costs of random_zipfian in pgbench Tom Lane <tgl@sss.pgh.pa.us>
Re: CPU costs of random_zipfian in pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: CPU costs of random_zipfian in pgbench Tom Lane <tgl@sss.pgh.pa.us>
Re: CPU costs of random_zipfian in pgbench Alvaro Herrera <alvherre@2ndquadrant.com>
Re: CPU costs of random_zipfian in pgbench Tom Lane <tgl@sss.pgh.pa.us>
Re: CPU costs of random_zipfian in pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: CPU costs of random_zipfian in pgbench Tom Lane <tgl@sss.pgh.pa.us>
Re: CPU costs of random_zipfian in pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: CPU costs of random_zipfian in pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: CPU costs of random_zipfian in pgbench Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: CPU costs of random_zipfian in pgbench Fabien COELHO <coelho@cri.ensmp.fr>
>> There are pretty good approximations for s > 1.0 using Riemann zeta >> function and Euler derived a formula for the s = 1 case. > > I believe that's what random_zipfian() already uses, because for s > 1.0 > it refers to "Non-Uniform Random Variate Generation" by Luc Devroye, and > the text references the zeta function. Yep. > Also, I have not observed serious issues with the s > 1.0 case (despite > the docs seem to suggest there may be some). The performance issue is for s > 1.0 and very close to 1.0, et things like s = 1.000001 >> I also noticed that i is int in this function, but n is int64. That >> seems like an oversight. Indeed, that is a bug! Using it for a really int64 value would be very bad, though. Maybe there should be an error if the value is too large, because calling pow billions of times is bad for the computer health. -- Fabien.
В списке pgsql-hackers по дате отправления