Don't pick a partial index for speed
Four index strategies on a 10M-row Postgres queue table: the winner didn't win for the reason I gave, and one setting turned it into a 1,635x loss.
All posts
Tag
#PostgreSQL
The PostgreSQL database: index strategies, the query planner, vacuum and performance.
There are 1 posts with this tag.