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