plan_cache_mode

Partial indexes on Postgres queues: 41x smaller, 6.9% faster, one bound parameter from 7 tps

A 10M-row benchmark on Postgres 17 found the partial index barely quicker than a composite, 41x smaller, and unusable under a generic plan, where throughput fell from 11,752 tps to 7.