Search Postgresql Archives

Re: Indexed views like SQL Server - NOT Materialized Views

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



2015-06-10 17:43 GMT+02:00 Kevin Grittner <kgrittn@xxxxxxxxx>:
inspector morse <inspectormorse86@xxxxxxxxx> 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@xxxxxxxxxxxxxx)
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 ?​


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux