Implications of many materialized views in Postgres?
2
votes
1
answer
1096
views
I'm working on a system that includes a scheduling component, which has support for recurring events. After reading many, many posts on storing recurring events, it was suggested that they be calculated for a specific time period using a Postgres function and then stored in a materialized view to avoid having to recalculate every time.
The system I'm working on serves multiple businesses, each with their own calendar and customers. My thought was that a materialized view would be created on a per-business basis. However, if the service is successful, there could be well over a 1000 businesses using the system. That said, are there issues with having that many materialized views? And if so, is there a better pattern that would scale as the service grows?
FYI: I'm running Postgres 9.4
Asked by jdixon04
(219 rep)
Oct 21, 2015, 05:26 AM
Last activity: Jun 1, 2025, 01:04 AM
Last activity: Jun 1, 2025, 01:04 AM