3 ms·
The problem with views in Postgres is that they are not updated on the fly, they require manual updating. For real time data, it's not a very useful feature.
by joaodlf 9y ago
The problem with views in Postgres is that they are not updated on the fly, they require manual updating. For real time data, it's not a very useful feature.
- kdv 9y agoErm I think you're thinking of materialized views. Regular views are essentially stored queries. https://www.postgresql.org/docs/10/static/rules-materializedviews.html https://www.postgresql.org/docs/10/static/rules-materialized...
- joaodlf 9y agoOh, yes. I tend not to gravitate towards views, so got myself mixed up there :).