[NicoJuicy]

Except the flat file part. What was lacking with postgress?

It has decent json support and v8 javascript build-in.

[rjeli]

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]

I 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/

[NicoJuicy]

Thanks for the informative answer!