Strange performance boost with random() - Mailing list pgsql-performance

From M Putz
Subject Strange performance boost with random()
Date
Msg-id alpine.DEB.2.02.1402102007580.14849@skaj
Whole thread Raw
Responses Re: Strange performance boost with random()
List pgsql-performance
Hello,

While analyzing performance, we encountered the following phenomenon,

   SELECT sum(pow(.5*generate_series,.5))
   FROM generate_series(1,1000000);

is much much (a hundred times) slower than

   SELECT sum(pow(random()*generate_series,.5))
   FROM generate_series(1,1000000);

and asymptotic difference is even more astounding.
This seems counter-intuitive, considering the cost of
an additional random() call instead of a constant factor.
What are the reasons for this strange performance boost?

Thanks, M. Putz



pgsql-performance by date:

Previous
From: Sergey Konoplev
Date:
Subject: Re: Bloated tables and why is vacuum full the only option
Next
From: Heikki Linnakangas
Date:
Subject: Re: Strange performance boost with random()