zlacker

[parent] [thread] 1 comments
1. glenja+(OP)[view] [source] 2026-01-25 16:21:36
A bitmap index scan allows the database to narrow down which pages could include the data, but then still has to recheck the condition on the contents of those pages - so will still not be as performant as an proper index scan
replies(1): >>isbvho+dG
2. isbvho+dG[view] [source] 2026-01-25 20:49:40
>>glenja+(OP)
With postgres indexes not containing liveness data for tuples you'll have to hit quite a lot of those pages anyway, unless they are frozen.
[go to top]