Test Citus (derived version of PostgreSQL) for columnar storage

[toniher]

Citus is a version of PostgreSQL that includes some extensions that may be interesting for some of our use cases. Concretely, about column storage that would be convenient for a couple of tables where we are performing aggregation.

It seems to be as easy as changing the schema of the candidate tables https://docs.citusdata.com/en/latest/admin_guide/table_management.html#columnar-storage

Last Citus 13.x version is compatible with Postgres 17.x, which we are using.

It should be a matter to benchmark the performance in a development or testing environment. It should be noticeably faster where aggregation functions are called, with no loss in the other scenarios.