Re: Indexed views like SQL Server - NOT Materialized Views

2015-06-10 17:43 GMT+02:00 Kevin Grittner <kgrittn(at)ymail(dot)com>:

> inspector morse <inspectormorse86(at)gmail(dot)com> wrote:
>
> > After doing that, if you add or delete a topic from the Topics
> > Table, SQL Server automatically keeps the count updated.....and
> > it's fast because of the unique index.
> >
> > Doing the same thing in Postgresql using Materialized views is
> > slow and the developer has to manually issue a "refresh
> > materialized view" command. The alternative is to write
> > additional sql to update count columns....uneccessary work.
> >
> > Do you know when Postgresql will implement such a feature?
>
> People are working toward such capabilities. While nobody can say
> with any certainty when such features will make it into a
> PostgreSQL release, I think it's safe to predict that it will not
> be before late 2017, and most probably later than that.
>
> This capability probably will be available through materialized
> views, rather than using the SQL Server syntax.
>
> --
> Kevin Grittner
> EDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
>> Hi,
>
>
>> Would views + partial indexes (based on views predicat) do the trick ?
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

​Hi,

Would views + partial indexes (based on views predicat) do the trick ?​