Re: Indexed views like SQL Server - NOT Materialized Views

From: Kevin Grittner <kgrittn(at)ymail(dot)com>
To: Nicolas Paris <niparisco(at)gmail(dot)com>
Cc: inspector morse <inspectormorse86(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Indexed views like SQL Server - NOT Materialized Views
Date: 2015-06-10 16:11:32
Message-ID: 1437974744.359985.1433952692403.JavaMail.yahoo@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Nicolas Paris <niparisco(at)gmail(dot)com> wrote:

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

I don't see anything promising that way, but feel free to work up a
proof of concept patch if you do.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Begin 2015-06-10 21:20:00 Re: Planner cost adjustments
Previous Message Nicolas Paris 2015-06-10 15:49:26 Re: Indexed views like SQL Server - NOT Materialized Views