Re:PostgreSQL: Jsonb has committed
by Tobu on Tuesday March 25, 2014 @05:09AM
(#7464695)
You're right, because MVCC works on immutable rows. The structure can be broken up to accommodate large values[1], which saves updating parts that don't change, but json data is a single column and updates need to copy the entire document.
[1] http://www.postgresql.org/docs/devel/static/storage-toast.ht...