Postgres Wasn't Ignoring My Index. On My Machine It Used the Index Too Often.
Why does Postgres skip indexes? On a 5M-row table the default planner picked a bitmap scan up to 1.85x slower than a sequential scan, and physical column order mattered more than selectivity.