Stephen Frost schrieb am 20.11.2018 um 18:28: > Oh yes, having a dictionary would be a great start to reducing the size > of the jsonb data, though it could then become a contention point if > there's a lot of new values being inserted and such. Naturally there > would also be a cost to pulling that data back out as well but likely it > would be well worth the benefit of not having to store the field names > repeatedly.
There is an extension for a dictionary based JSONB compression: https://github.com/postgrespro/zson
