4 ms·
Do these satisfy the compression requirement? https://stackoverflow.com/questions/1369864/does-postgresql-support-transparent-compressing-of-tables-fragments h
by wlll 7y ago
Do these satisfy the compression requirement?
https://stackoverflow.com/questions/1369864/does-postgresql-support-transparent-compressing-of-tables-fragments https://stackoverflow.com/questions/1369864/does-postgresql-...
- ddorian43 7y agoNo. LSM/Rocksdb databases do "block compressions". Even better is dynamic dictionary compression: https://github.com/facebook/rocksdb/wiki/Dictionary-Compression https://github.com/facebook/rocksdb/wiki/Dictionary-Compress...
- willvarfar 7y agoNo, that's a compressed row format, not a compressed block format. MySQL's innodb, for example, supports per-row-compression. Its completely ineffective. Block compression in tokdub and myrocks etc is a completely different class. MySQL's innodb also supporta kind of 'page compression' using the file-system's sparse pages. Its also naff. The closest postgres can get is using zfs with compression. Its a lot better than nothing.
- wlll 7y agoYeah, one of the suggestions on that page was a compressed filesystem.