Shrink a Postgres Index by Indexing Only the Rows You Query
Share

A partial index on 50,000 pending jobs was 1.1 MB instead of 150 MB, and the query was just as fast

 

 A partial index on 50,000 pending jobs was 1.1 MB instead of 150 MB, and the query was just as fastContinue reading on Medium » Read More Sql on Medium 

#sql

By ali

Leave a Reply