4 ms·
The problem there would be how they fall out of date, and updating them is a heavy operation. An alternative I've heard before is using triggers with regular t
by Izkata 3y ago
The problem there would be how they fall out of date, and updating them is a heavy operation.
An alternative I've heard before is using triggers with regular tables, so updating one automatically updates the relevant other ones.
- r00fus 3y agoMaterialized views allow insert/update mechanics on many platforms. Alternatively you can refresh them.