Views v.s. materialized Views v.s. Rollup Tables with PostgreSQL
6 min readMar 18, 2020
For applications it’s often really annoying to aggregate data in memory with a self written command/program instead of having this already done by the storage engine, which holds the data. The point is, it’s really cumbersome to fetch data from a database, aggregate it within a program and write it to another table, which will be used as data source for another program. When you…