4 ms·
It's called a materialized view.
by solipsism 5y ago
It's called a materialized view.
- tshaddox 5y agoThat’s one implementation of a similar idea in RDBMSs, although they generally require manually refreshing them when desired. I think I’ve heard that some RDBMSs also allow you to apply normal inserts and updates to materialized views if you want to manually keep them up to date as well, although I’ve never tried that approach.
- vaughan 5y agoIt’s called incremental view maintenance. Check out: https://wiki.postgresql.org/wiki/Incremental_View_Maintenance https://wiki.postgresql.org/wiki/Incremental_View_Maintenanc...
- solipsism 5y agoManually refreshing them? How could such a process possibly be manual but not automatable? Does it involve turning a crank?