Skip to content
Better HN
Top
New
Best
Ask
Show
Jobs
Search
⌘K
undefined | Better HN
0 points
syncsynchalt
1y ago
0 comments
Share
> Postgres can’t update a JSON object on disk, it just rewrites the entire blob.
Postgres does this for _all_ row updates; it must, for transaction isolation to work.
0 comments
default
newest
oldest
hashhar
1y 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.
syncsynchalt
OP
1y ago
Did not know this; thank you!
j
/
k
navigate · click thread line to collapse