Re: Do we still need constraint_exclusion?

Поиск
Список
Период
Сортировка
От Dimitri Fontaine
Тема Re: Do we still need constraint_exclusion?
Дата
Msg-id A76FB8ED-7923-4E89-A308-313CAD3805CF@hi-media.com
обсуждение исходный текст
Ответ на Re: Do we still need constraint_exclusion?  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-hackers
Le 7 janv. 09 à 22:21, Simon Riggs <simon@2ndQuadrant.com> a écrit :

>
> On Wed, 2009-01-07 at 12:54 -0500, Tom Lane wrote:
>
>> So, barring objections, I'll go make this happen.
>
> I don't really understand this. Who can set up an inherited table
> structure but can't remember to turn on constraint_exclusion? That is
> the easiest part of the whole process by a long way. Nobody has this
> table design by accident, they've all been told how or read the docs.
>
> I'm not against the change so much as bemused by it.

I think the improvement is not in the usability part but the
performance benefit of avoiding lots of cpu cycles when there's no
gain to hope.

And I like the new option!
--
dim

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Significant oversight in that #include-removal script
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: Latest version of Hot Standby patch