I believe it can speed it up by using index only scans along with the visibility...

aidos on April 6, 2021 | parent | context | favorite | on: Things I hate about PostgreSQL (2020)

I believe it can speed it up by using index only scans along with the visibility_map which effectively tells it which entries are “current” in more broad strokes.