Alternative databases

I am investigating whether we could achieve better performance with an alternative database. Our queries typically do a lot of aggregation, so a column-store database might be more performant. Alternatively/additionally, many of our queries could benefit from materialized view which could be incrementally updated. Only the most recent incoming data needs to update rows. After a while, data is generally static (except for schema updates).

ClickHouse

TimescaleDB

• Time-series aggregates can't contain joins.

Citus

• No foreign keys
• No updates/deletes

Materialize

Pinot

PipelineDB

• Defunct