Any work being done on materialized view?

Started by inspector morseover 9 years ago2 messagesgeneral
Jump to latest
#1inspector morse
inspectormorse86@gmail.com

Is there any work being done on materialized views for version 9.7? This
postgresql feature is severely lacking compared to similar features like
indexed views by sql server.

#2Melvin Davidson
melvin6925@gmail.com
In reply to: inspector morse (#1)
Re: Any work being done on materialized view?

What exactly are the features you are looking for? Materialized views are
treated as tables in PostgreSQL and you can create indexes on them.

https://www.postgresql.org/docs/9.4/static/sql-creatematerializedview.html

"CREATE MATERIALIZED VIEW is *similar to **CREATE TABLE* AS, except that it
also remembers the query used to initialize the view, so that it can be
refreshed later upon demand. *A materialized view has many of the same
properties as a table*, but there is no support for temporary materialized
views or automatic generation of OIDs."

On Sat, Dec 3, 2016 at 8:55 AM, inspector morse <inspectormorse86@gmail.com>
wrote:

Is there any work being done on materialized views for version 9.7? This
postgresql feature is severely lacking compared to similar features like
indexed views by sql server.

--
*Melvin Davidson*
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.