Hacker News new | ask | show | jobs
by hashhar 622 days ago
I'm not sure, there's also HOT-updates (heap-only tuples). It's an optimization where data in modified in place if none of the modified columns are part of an index and maybe other conditions but I don't remember it all too well.
1 comments

Did not know this; thank you!