Hello 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?
Regards
Pavel Stehule
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
