PostgreSQL OLAP

Materialized Views vs Rollups

• Materialized views vs. Rollup tables in Postgres (Citus)
• Choice depends on data volume and real-time requirements.

Incremental Aggregation

• Scalable incremental data aggregation on Postgres and Citus

Extensions

• citusdata/postgresql-hll - HyperLogLog for distinct counts.
• citusdata/postgresql-topn - TopN extension.
• postgres-plr/plr - R language support.