citus
citus copied to clipboard
citusdata
Support more compression methods for columnar (e.g. lz4hc)
Columnar storage page lists a lot of format limitations, including
No support for foreign keys, unique constraints, or exclusion constraints
But Citus updates post claims:
With the index support on columnar tables, Citus 10.2 supports the following constraints on columnar tables: primary keys, unique constraints, and exclude constraints.
This was a deciding factor for me and I almost declined Citus option when making a decision. If it's indeed supported, can someone fix the readme inaccuracy, please.
Besides, I get "unknown compression type for columnar table: lz4hc" on Ubuntu 20.04 LTS. Is the -hc version deprecated at all? https://github.com/lz4/lz4/issues/660
Columnar storage page lists a lot of format limitations, including
No support for foreign keys, unique constraints, or exclusion constraints
But Citus updates post claims:
With the index support on columnar tables, Citus 10.2 supports the following constraints on columnar tables: primary keys, unique constraints, and exclude constraints.
This was a deciding factor for me and I almost declined Citus option when making a decision. If it's indeed supported, can someone fix the readme inaccuracy, please.
Thank you for reporting this and contributions are always welcome! :)
Besides, I get "unknown compression type for columnar table: lz4hc" on Ubuntu 20.04 LTS. Is the -hc version deprecated at all? lz4/lz4#660
This is because Citus columnar only supports pglz, lz4 and zstd atm; does any of those fit in your use-case ?
I'm too unexperienced with Citus yet to contribute to the docs :-) Sure, pglz, lz4 and zstd will work, but I was just testing all options on my particular dataset to compare by size & access speed, and lz4hc was advertised everywhere in the docs, what's why I was surprised by the error.
If you don't support lz4hc can you at least remove the option from the docs?
