Re: [PERFORM] pgbench to the MAXINT
От | Stephen Frost |
---|---|
Тема | Re: [PERFORM] pgbench to the MAXINT |
Дата | |
Msg-id | 20110211133551.GE4116@tamriel.snowman.net обсуждение исходный текст |
Ответ на | Re: [PERFORM] pgbench to the MAXINT (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: [PERFORM] pgbench to the MAXINT
|
Список | pgsql-hackers |
Greg, * Tom Lane (tgl@sss.pgh.pa.us) wrote: > Greg Smith <greg@2ndquadrant.com> writes: > > Poking around a bit more, I just discovered another possible approach is > > to use erand48 instead of rand in pgbench, which is either provided by > > the OS or emulated in src/port/erand48.c That's way more resolution > > than needed here, given that 2^48 pgbench accounts would be a scale of > > 2.8M, which makes for a database of about 42 petabytes. > > I think that might be a good idea --- it'd reduce the cross-platform > variability of the results quite a bit, I suspect. random() is not > to be trusted everywhere, but I think erand48 is pretty much the same > wherever it exists at all (and src/port/ provides it elsewhere). Works for me. Greg, will you be able to work on this change? If not, I might be able to. Thanks, Stephen
В списке pgsql-hackers по дате отправления: