A bitmap index scan allows the database to narrow down which pages could include... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		glenjamin 38 days ago \| parent \| context \| favorite \| on: Introduction to PostgreSQL Indexes 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

isbvhodnvemrwvn 37 days ago [–]

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.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact