I found lot of slow queries in some databases which I checked based on
advice 4.1. from FAQ,

 To SELECT a random row, use:
    SELECT col
    FROM tab
    ORDER BY random()
    LIMIT 1;

It's robust and slow on bigger tables. Can we add some better solutions?

Pavel Stehule

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to