postgresql
One WEIRD Trick for Speeding Up ORDER BY That You Probably Shouldn't Use
I was digging into a performance issue at work recently and found THE WEIRDEST way of speeding up a query that uses ORDER BY. When testing against our replica database, I was getting results up to 100 times faster than before.