Re: Materialized views and unique indexes

From: Craig Ringer <craig(at)2ndquadrant(dot)com>
To: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
Cc: Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Materialized views and unique indexes
Date: 2013-03-08 03:08:27
Message-ID: 5139562B.9010806@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 03/08/2013 10:55 AM, Michael Paquier wrote:
> Also, as it is not mandatory for a unique index to be a constraint, I
> think that we should block the creation of unique indexes too to avoid
> any problems. Any suggestions?
How much does the planner benefit from the implied constraint of a
unique index? I almost wonder if it should be allowed at the cost of
making the refresh of a matview that fails to comply an error.

--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2013-03-08 03:31:07 Re: Enabling Checksums
Previous Message Michael Paquier 2013-03-08 02:55:07 Re: Materialized views and unique indexes