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 обсуждение исходный текст |
| Ответ на | 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)
|
| Список | pgsql-hackers |
> 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 по дате отправления: