Re: BUG #13453: PostgreSQL 9.5dev pgbench exponential distribution bug? (when threshold is small) - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: BUG #13453: PostgreSQL 9.5dev pgbench exponential distribution bug? (when threshold is small)
Date
Msg-id 20150618153221.GG133018@postgresql.org
Whole thread Raw
In response to Re: BUG #13453: PostgreSQL 9.5dev pgbench exponential distribution bug? (when threshold is small)  (Fabien COELHO <coelho@cri.ensmp.fr>)
Responses Re: BUG #13453: PostgreSQL 9.5dev pgbench exponential distribution bug? (when threshold is small)
List pgsql-bugs
Fabien COELHO wrote:
>
> Hello,
>
> >\setrandom id 1 50000 exponential 0.0000001
> >insert into test values (:id);
>
> Yes, a very small coefficient on a truncated exponential is pretty close to
> a uniform distribution. I think that this is a mathematical fact, not a bug.

It's a fact of life also ... you don't notice exponentially-growing
stuff until it's way out of hand :-)

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-bugs by date:

Previous
From: Fabien COELHO
Date:
Subject: Re: BUG #13452: postgresql 9.5dev pgbench document problem.
Next
From: Tom Lane
Date:
Subject: Re: BUG #13440: unaccent does not remove all diacritics