3 ms·
No compression of json docs. Jsonb is even bigger than json text column. There’s an extension out there but it requires manual compression passes and doesn’t al
by rjeli 5y ago
No compression of json docs. Jsonb is even bigger than json text column. There’s an extension out there but it requires manual compression passes and doesn’t allow indexing. Might as well use SQLite
- mnahkies 5y agoI think it would probably just make sense to run postgres on a compressed filesystem rather than use an extension. Looks like citus had good results: https://www.citusdata.com/blog/2013/04/30/zfs-compression/ https://www.citusdata.com/blog/2013/04/30/zfs-compression/
- NicoJuicy 5y agoThanks for the informative answer!