Comment on Optimizing Postgres table layout for maximum efficiencyparentComments−syncsynchalt1yPostgres 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.−hashhar1yI'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.−syncsynchalt1yDid not know this; thank you!
Comments
Postgres does this for _all_ row updates; it must, for transaction isolation to work.
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.
Did not know this; thank you!