Postgres not using your index? It’s counting pages, not rows
Share

You get a Seq Scan even with an index because the planner prices a query in pages, and a small table is cheaper to read whole.

 

 You get a Seq Scan even with an index because the planner prices a query in pages, and a small table is cheaper to read whole.Continue reading on Medium » Read More Sql on Medium 

#sql

By ali

Leave a Reply