medium10 pts · first answer countsindexingpostgresql

Indexing only pending rows

A 200 million row jobs table has only a few thousand rows with status = 'pending', and workers always query those. Which index is the best fit?

A.CREATE INDEX ON jobs (status);B.CREATE INDEX ON jobs (created_at) WHERE status = 'pending';C.A hash index on every columnD.No index; sequential scans are fine at this size

← A migration froze the whole app Searching inside text →