undefined | Better HN

0 pointssyncsynchalt1y ago0 comments

> 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

2 comments · 1 top-level

hashhar1y ago· 1 in thread

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.

syncsynchaltOP1y ago

Did not know this; thank you!

j / k navigate · click thread line to collapse