Roast topics
Find topics
Roast it!
Roast topics
Find topics
Find it!
Login
From:
pganalyze
(Uncensored)
subscribe
Postgres Planner Quirks: The impact of ORDER BY + LIMIT on index usage
https://pganalyze.com/blog/5mins-postgres-planner-order-by-limit
links
backlinks
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.
