Don't pick a partial index for speed: what I measured on a 10M-row Postgres queue table
DEV Community
Don't pick a partial index for speed: what I measured on a 10M-row Postgres queue table
Four index strategies, three table sizes, pgbench. The partial index won — but not for the reason I gave when I recommended it, and one setting turns the win into a 1,673x loss.
0 comments
No comments yet.