Menu
I finished my course on Oracle databases and have been playing with it since sometime. One of my friends told me that PostgreSQL is a very good database management system which has object oriented capabilities.
On an Oracle database, it is a straightforward and easy process to create materialized views. BUT despite of having heard that PostgreSQL supports materialized views from few people, I am unable to figure out how to do that.
Please advise.
740
A “materialized view” is a database object which stores the result of a precalculated database query and makes it easy to refresh this result as needed. Materialized views are an integral feature of pretty much all advanced database systems.
Parameters. Refresh the materialized view without locking out concurrent selects on the materialized view. Without this option a refresh which affects a lot of rows will tend to use fewer resources and complete more quickly, but could block other connections which are trying to read from the materialized view.
A materialized view is much more efficient at executing queries. The data is physically saved at a specific point in time. You don't need to re-read all the data associated with a query every single time. The drawback is that you have to make sure to view the most recent data.
For PostgreSQL version 9.2 and below, read the following article on how to create materialized views by using functions and triggers.
Since version 9.3, materialized views are natively supported:
For more information on this topic, please refer to the following articles on PostgreSQL documentation:
80
There's no native support for materialized views in postgres.
You could try to emulate them with triggers/stored procedures as described in this article.
33
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
