Hacker News new | ask | show | jobs
by agacera 3193 days ago
Probably it is needed to check if the row is still visible to that transaction.
1 comments

Postgres uses a visibility bitmap [1] to avoid hitting the heap merely to determine visibility of stable data.

[1] https://www.postgresql.org/docs/9.6/static/indexes-index-onl...