Re: query plan ignoring check constraints - Mailing list pgsql-hackers

From John Hansen
Subject Re: query plan ignoring check constraints
Date
Msg-id 5066E5A966339E42AA04BA10BA706AE50A9365@rodrick.geeknet.com.au
Whole thread Raw
In response to query plan ignoring check constraints  (Rohit Gaddi <rohitgaddi@yahoo.co.in>)
Responses Re: query plan ignoring check constraints
List pgsql-hackers
Bruno Wolff III [mailto:bruno@wolff.to] Wrote:

> You only want to use partial indexes when they don't cover
> the whole table. They make sense to enforce uniqueness of a
> column under some condition and when you can save significant
> space (becuase the condition is only satisfied for a small
> fraction of rows).


Yes, I know that,.

I misunderstood the original post as a request for queries NOT to use
indexes where it doesn't match the table contents.

.. John


pgsql-hackers by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: query plan ignoring check constraints
Next
From: Bruno Wolff III
Date:
Subject: Re: query plan ignoring check constraints