2 ms·
Materialized views "Didn’t auto-refresh"? Maybe I'm dumb or not getting it, but if it doesn't automatically refresh (it should be straight up transactional), th
by MichaelGG 13y ago
Materialized views "Didn’t auto-refresh"? Maybe I'm dumb or not getting it, but if it doesn't automatically refresh (it should be straight up transactional), then what's the benefit over a normal table? Just a perf gain for queries you can't modify (but can have non-transactional/stale data)?
- paperwork 13y agoI'm using them. Without them, I'd have to periodically load my main table and, in the same process, insert data derived from main table to summary tables. Now I can just setup materialized views and after I'm done loading data into the main table, just 'refresh' and expect all materialized views will to be synced. Somehow, it feels like a much lighter cognitive load on my brain.