Sample Header Ad - 728x90

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