Postgres Planner Quirks: The impact of ORDER BY + LIMIT on index usage 

Find the article on our blog here:
pganalyze.com/...
In E113 of "5mins of Postgres" we discuss a commonly encountered Postgres planner quirk, which is how Postgres behaves when you have a LIMIT and an ORDER BY clause, and it picks the wrong index.
Learn more about pganalyze:
pganalyze.com
pganalyze.com/...
/ pganalyze
Check out the pganalyze library for eBooks, webinars, and more:
pganalyze.com/...
📑 What we have discussed in this episode of 5mins of Postgres:
DBA StackExchange - Poor performance on query with LIMIT when I add an ORDER BY?
dba.stackexcha...
Why is there a Sort after an Index Only Scan? - Mailinglist discussion on pgsql-performance
www.postgresql...
Example of bad ORDER BY + LIMIT on dbfiddle
dbfiddle.uk/D7...
Debugging the Postgres query planner
gocardless.com...
pg_hint_plan
github.com/oss...
Recent Hacker News discussion on pg_hint_plan, including discussion of the ORDER BY + LIMIT problem
news.ycombinat...
One WEIRD Trick for Speeding Up ORDER BY That You Probably Shouldn't Use - Blog post by Cassidy on DEV Community
dev.to/cassidy...