Hacker News
new
|
past
|
comments
|
ask
|
show
|
jobs
|
submit
login
Tobu
on March 25, 2014
|
parent
|
context
|
favorite
| on:
PostgreSQL: Jsonb has committed
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...
Consider applying for YC's W25 batch! Applications are open till Nov 12.
Guidelines
|
FAQ
|
Lists
|
API
|
Security
|
Legal
|
Apply to YC
|
Contact
Search:
[1] http://www.postgresql.org/docs/devel/static/storage-toast.ht...