PostgreSQL OLAP
约 1 分钟阅读
Materialized Views vs Rollups
- Materialized views vs. Rollup tables in Postgres (Citus)
- Choice depends on data volume and real-time requirements.
Incremental Aggregation
Extensions
- citusdata/postgresql-hllGitHubcitusdata/postgresql-hll - HyperLogLog for distinct counts.
- citusdata/postgresql-topnGitHubcitusdata/postgresql-topn - TopN extension.
- postgres-plr/plrGitHubpostgres-plr/plr - R language support.
关联信息
反向链接、本文链接的其他页面和外部资料。
参考资料
GitHub3 条
- citusdata/postgresql-hllgithub.com/citusdata/postgresql-hll
- citusdata/postgresql-topngithub.com/citusdata/postgresql-topn
- postgres-plr/plrgithub.com/postgres-plr/plr
其他外链2 条
- www.citusdata.com/blog/2018/06/14/scalable-incremental-data-aggregationwww.citusdata.com/blog/2018/06/14/scalable-incremental-data-aggregation
- www.citusdata.com/blog/2018/10/31/materialized-views-vs-rollup-tableswww.citusdata.com/blog/2018/10/31/materialized-views-vs-rollup-tables