[Web Feed] Tom Witowsky (@devgummibeer) shared on Twitter a scaling issue with his servi...

..ce opendor.me, which helps any developer share and highlight th



Tom Witowsky (
twitter.com/devgummibeer: @devgummibeer) shared on Twitter a scaling issue with his service 
opendor.me/: opendor.me, which helps any developer share and highlight their open source work. As the service grows, more and more data is stored in the database and needs to be browsed. One particularly slow query that he needed help optimizing is fetching random users, organizations, and repositories that are already part of the service.

The following query illustrates the problem reduced to its important component:



SELECT * FROM repositories ORDER BY RANDOM() LIMIT 3







Link 1


How to optimize ORDER BY RANDOM() | Tobias’s Blog: https://tpetry.me/20210507-how-to-optimize-order-by-random