2015-06-10 17:43 GMT+02:00 Kevin Grittner <kgri...@ymail.com>: > inspector morse <inspectormors...@gmail.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@postgresql.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 ?
