Comment

Comment by giovannibonetti

Partial indexes solve exactly this problem. You add a WHERE condition that restricts the index to a subset of the whole table.

Discussion

Live from the official Hacker News API

A modern reader for Hacker News · SvelteKit + Skeleton