Originally from the User Slack
@Benaceur_Ayoub: Hi, if I have 7 materialized views on one table to support some queries would that hurt performance too much? Also what’s the maximum mv tables you can have per table ?
@Felipe_Cardeneti_Mendes: There’s no pre-defined maximum as its down to your own judgement. Considering every view has a distinct key not part of the base table, then every write operation will require * VIEW_COUNT view updates.
If you run 1 ops/sec, that’s 8 updates (base table + 7 views). If you write 100K/s, that’s 800K updates.
The former is fine. The latter is likely not going to scale well.