I’m waiting for proper resource limits. At the moment anything involving columnar tables ignores the memory limits, so it’s trivial to crash the server if your table has the right sort of data.
Indeed,
it seems Citus is approaching Vertica territory, but in open source.
For what it is worth, Vertica also does not support triggers (unless things changed more recently)
Impressive changelog entry: https://github.com/citusdata/citus/blob/master/CHANGELOG.md#citus-v1102-june-15-2022
What I was awaiting the most is:
I’m waiting for proper resource limits. At the moment anything involving columnar tables ignores the memory limits, so it’s trivial to crash the server if your table has the right sort of data.
Indeed, it seems Citus is approaching Vertica territory, but in open source. For what it is worth, Vertica also does not support triggers (unless things changed more recently)
triggers are now officially supported in citus (you could already do it by (ab)using https://docs.citusdata.com/en/v11.0/develop/reference_propagation.html