Re: query plan ignoring check constraints

Поиск
Список
Период
Сортировка
От John Hansen
Тема Re: query plan ignoring check constraints
Дата
Msg-id 5066E5A966339E42AA04BA10BA706AE50A9365@rodrick.geeknet.com.au
обсуждение исходный текст
Ответ на query plan ignoring check constraints  (Rohit Gaddi <rohitgaddi@yahoo.co.in>)
Ответы Re: query plan ignoring check constraints
Список 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 по дате отправления:

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: query plan ignoring check constraints
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: query plan ignoring check constraints