Re: Performance of ORDER BY RANDOM to select random rows?

On Thu, Aug 08, 2013 at 12:01:17PM +1000, Victor Hooi wrote:
> I'm just wondering if this is still the case?

Yes. Order by random() is and, most likely, will be slow. Not sure if
there is any engine that could make it fast.

> I just ran those benchmarks on my system (Postgres 9.2.4), and using ORDERY
> BY RANDOM did not seem substantially to generating random integers in
> Python and picking those out (and handling non-existent rows).

I think you accidentally a word.

depesz

--
The best thing about modern society is how easy it is to avoid contact with it.
                                                             http://depesz.com/