Re:Using PostgreSQL’s JSONB for NoSQL (2019) [video]
by fabian2k on Sunday September 05, 2021 @09:05AM
(#28424045)
In Postgres you would generally use JSONB columns, those are stored as TOASTs and are automatically compressed. That compression isn't very good, but there is some work on adding other compression algorithms there.
[ Parent
| on HN ]
Re:Using PostgreSQL’s JSONB for NoSQL (2019) [video]
by tpetry on Sunday September 05, 2021 @10:18AM
(#28424529)
PostgreSQL 14 will add lz4 compression for toast data. But if i remember correctly the first ~700 bytes are always stored inline and only the rest is compressed. But i could be wrong on this.