Joseph Shraibman <jks@selectacast.net> writes:
> Is there a way to get random rows besides ORDER BY random()?
Are you willing to expend an extra column in the table, plus an index on
the column, to make this fast? Then you can do it --- see discussion
just a few days ago.
http://archives.postgresql.org/pgsql-performance/2003-08/msg00526.php
If you are willing to settle for "only approximately random", you might
be able to use the primary key as a pseudo-random value. Again, see
prior discussion.
regards, tom lane
