Re: Effects of GUC settings on automatic replans

Поиск
Список
Период
Сортировка
От Jim Nasby
Тема Re: Effects of GUC settings on automatic replans
Дата
Msg-id 4DCB6439-B0B2-4654-9040-B94AFADD054F@decibel.org
обсуждение исходный текст
Ответ на Effects of GUC settings on automatic replans  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Effects of GUC settings on automatic replans  (Gregory Stark <stark@enterprisedb.com>)
Re: Effects of GUC settings on automatic replans  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Mar 21, 2007, at 5:11 AM, Tom Lane wrote:
>     constraint_exclusion
>
> I'm inclined not to worry about these, since changing them can't  
> affect
> the semantics of the query, at worst its performance.

Hrm... wasn't that option added in case there was a bug in the  
exclusion code? I certainly can't think of any performance reason why  
you'd want to disable it... so it might be worth invalidating plans  
if it changes.
--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)




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

Предыдущее
От: Jim Nasby
Дата:
Сообщение: Vacation
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Grouped Index Tuples / Clustered Indexes