On Sun, Aug 18, 2024 at 9:56 PM Stephen Samuel (Sam) <s...@sksamuel.com> wrote: > My question is, why isn't it using the index for column b? Is this expected? > And why is it doing heap lookups for every row,.
This has been fixed for Postgres 17: https://pganalyze.com/blog/5mins-postgres-17-faster-btree-index-scans -- Peter Geoghegan