4 ms·
Except the flat file part. What was lacking with postgress? It has decent json support and v8 javascript build-in.
by NicoJuicy 6y ago
Except the flat file part. What was lacking with postgress?
It has decent json support and v8 javascript build-in.
- rjeli 6y agoNo 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 6y 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 6y agoThanks for the informative answer!