Postgres partial indexes: the read gains, the write trap, and the covering pattern
Partial indexes in Postgres speed up filtered reads and can also cut UPDATE throughput by 40%. Here is the full picture: the selectivity threshold, HOT updates, and covering partial indexes.
By FlowVerify Editorial Team