the.bay.news

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

Sign in to join the discussion — your thebay.events account works here.

No comments yet.