Re: random() (was Re: New GUC to sample log queries)

Поиск
Список
Период
Сортировка
Искать
От
Fabien COELHO
Тема
Re: random() (was Re: New GUC to sample log queries)
Дата
Msg-id
alpine.DEB.2.21.1812280936010.32444@lancre
Ответ на
Список
Дерево обсуждения
New GUC to sample log queries Adrien Nayrat <adrien.nayrat@anayrat.info>
Re: New GUC to sample log queries David Rowley <david.rowley@2ndquadrant.com>
Re: New GUC to sample log queries Adrien Nayrat <adrien.nayrat@anayrat.info>
Re: New GUC to sample log queries Michael Paquier <michael@paquier.xyz>
Re: New GUC to sample log queries Adrien Nayrat <adrien.nayrat@anayrat.info>
Re: New GUC to sample log queries Vik Fearing <vik.fearing@2ndquadrant.com>
Re: New GUC to sample log queries Adrien Nayrat <adrien.nayrat@anayrat.info>
Re: New GUC to sample log queries Adrien Nayrat <adrien.nayrat@anayrat.info>
Re: New GUC to sample log queries Vik Fearing <vik.fearing@2ndquadrant.com>
Re: New GUC to sample log queries Robert Haas <robertmhaas@gmail.com>
Re: New GUC to sample log queries Adrien Nayrat <adrien.nayrat@anayrat.info>
Re: New GUC to sample log queries Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: New GUC to sample log queries Dmitry Dolgov <9erthalion6@gmail.com>
Re: New GUC to sample log queries Adrien Nayrat <adrien.nayrat@anayrat.info>
Re: New GUC to sample log queries Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: New GUC to sample log queries Dmitry Dolgov <9erthalion6@gmail.com>
Re: New GUC to sample log queries Adrien Nayrat <adrien.nayrat@anayrat.info>
Re: New GUC to sample log queries Vik Fearing <vik.fearing@2ndquadrant.com>
Re: New GUC to sample log queries Thomas Munro <thomas.munro@enterprisedb.com>
Re: New GUC to sample log queries Adrien Nayrat <adrien.nayrat@anayrat.info>
Re: New GUC to sample log queries Alvaro Herrera <alvherre@2ndquadrant.com>
Re: New GUC to sample log queries Adrien NAYRAT <adrien.nayrat@anayrat.info>
Re: New GUC to sample log queries Alvaro Herrera <alvherre@2ndquadrant.com>
Re: New GUC to sample log queries Adrien Nayrat <adrien.nayrat@anayrat.info>
Re: New GUC to sample log queries Alvaro Herrera <alvherre@2ndquadrant.com>
Re: New GUC to sample log queries Adrien NAYRAT <adrien.nayrat@anayrat.info>
random() (was Re: New GUC to sample log queries) Tom Lane <tgl@sss.pgh.pa.us>
Re: random() (was Re: New GUC to sample log queries) Michael Paquier <michael@paquier.xyz>
Re: random() (was Re: New GUC to sample log queries) Tom Lane <tgl@sss.pgh.pa.us>
Re: random() (was Re: New GUC to sample log queries) Michael Paquier <michael@paquier.xyz>
Re: random() (was Re: New GUC to sample log queries) Peter Geoghegan <pg@bowt.ie>
Re: random() (was Re: New GUC to sample log queries) Tom Lane <tgl@sss.pgh.pa.us>
Re: random() (was Re: New GUC to sample log queries) Peter Geoghegan <pg@bowt.ie>
Re: random() (was Re: New GUC to sample log queries) Tom Lane <tgl@sss.pgh.pa.us>
Re: random() (was Re: New GUC to sample log queries) Tom Lane <tgl@sss.pgh.pa.us>
Re: random() (was Re: New GUC to sample log queries) Tom Lane <tgl@sss.pgh.pa.us>
Re: random() (was Re: New GUC to sample log queries) Thomas Munro <thomas.munro@enterprisedb.com>
Re: random() (was Re: New GUC to sample log queries) Tom Lane <tgl@sss.pgh.pa.us>
Re: random() (was Re: New GUC to sample log queries) Tom Lane <tgl@sss.pgh.pa.us>
Re: random() (was Re: New GUC to sample log queries) Tom Lane <tgl@sss.pgh.pa.us>
Re: random() (was Re: New GUC to sample log queries) Thomas Munro <thomas.munro@enterprisedb.com>
Re: random() (was Re: New GUC to sample log queries) Tom Lane <tgl@sss.pgh.pa.us>
Re: random() (was Re: New GUC to sample log queries) Tom Lane <tgl@sss.pgh.pa.us>
Re: random() (was Re: New GUC to sample log queries) Adrien NAYRAT <adrien.nayrat@anayrat.info>
Re: random() (was Re: New GUC to sample log queries) Fabien COELHO <coelho@cri.ensmp.fr>
Re: random() (was Re: New GUC to sample log queries) Tom Lane <tgl@sss.pgh.pa.us>
Re: random() (was Re: New GUC to sample log queries) Fabien COELHO <coelho@cri.ensmp.fr>
Re: random() (was Re: New GUC to sample log queries) Tom Lane <tgl@sss.pgh.pa.us>
Re: random() (was Re: New GUC to sample log queries) Fabien COELHO <coelho@cri.ensmp.fr>
Re: random() (was Re: New GUC to sample log queries) Fabien COELHO <coelho@cri.ensmp.fr>
Re: random() (was Re: New GUC to sample log queries) Fabien COELHO <coelho@cri.ensmp.fr>
Re: random() (was Re: New GUC to sample log queries) Peter Geoghegan <pg@bowt.ie>
Re: random() (was Re: New GUC to sample log queries) Tom Lane <tgl@sss.pgh.pa.us>
Re: random() (was Re: New GUC to sample log queries) Peter Geoghegan <pg@bowt.ie>
Re: random() (was Re: New GUC to sample log queries) Peter Geoghegan <pg@bowt.ie>
Re: random() (was Re: New GUC to sample log queries) Tom Lane <tgl@sss.pgh.pa.us>
Re: random() (was Re: New GUC to sample log queries) Peter Geoghegan <pg@bowt.ie>
Re: random() (was Re: New GUC to sample log queries) Tom Lane <tgl@sss.pgh.pa.us>
Re: random() (was Re: New GUC to sample log queries) Peter Geoghegan <pg@bowt.ie>
Re: New GUC to sample log queries Sergei Kornilov <sk@zsrv.org>
Re: New GUC to sample log queries Alvaro Herrera <alvherre@2ndquadrant.com>
Re: New GUC to sample log queries Sergei Kornilov <sk@zsrv.org>
Re: New GUC to sample log queries Alvaro Herrera <alvherre@2ndquadrant.com>
Re: New GUC to sample log queries Nikolay Samokhvalov <samokhvalov@gmail.com>
Re: New GUC to sample log queries Adrien NAYRAT <adrien.nayrat@anayrat.info>
Re: New GUC to sample log queries Dmitry Dolgov <9erthalion6@gmail.com>
Re: New GUC to sample log queries Michael Paquier <michael@paquier.xyz>
Re: New GUC to sample log queries Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: New GUC to sample log queries Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: New GUC to sample log queries Adrien Mobile <adrien.nayrat@anayrat.info>

> About costs, not counting array accesses:
>
> - lrand48 (48 bits state as 3 uint16)        is 29 ops
>   (10 =, 8 *, 7 +, 4 >>)
> - xorshift+ (128 bits state as 2 uint64)     is 13 ops
>   ( 5 =, 0 *, 1 +, 3 >>, 4 ^)
> - xororshift128+ (idem)                      is 17 ops
>   ( 6 =, 0 *, 1 +, 5 >>, 3 ^, 2 |, less if rot in hardware)
> - WELL512 (512 bits state as 16 uint32)      is 38 ops
>   (11 =, 0 *, 3 +, 7 >>, 10 ^, 4 &)
>   probably much better, but probably slower than the current version
>
> I'd be of the (debatable) opinion that we could use xororshift128+, already 
> used by various languages, even if it fails some specialized tests.

After some more digging, the better choice seems to be the 64 bits 
optimized xoshiro256** (xoshiro = xor shift rotate):

  - xoshiro256** (256 bits states as 4 uint64) is 24 ops (18 if rot in hw)
    8 =, 2 *, 2 +, 5 <<, 5 ^, 2 |

See http://vigna.di.unimi.it/xorshift/

-- 
Fabien.

В списке pgsql-hackers по дате отправления
От: Masahiko Sawada
Дата:
От: Mitar
Дата:
FAQ