Postgres Pro
Downloads
Home   >   mailing lists

Re: Effects of GUC settings on automatic replans - Mailing list pgsql-hackers

From Jim Nasby
Subject Re: Effects of GUC settings on automatic replans
Date
Msg-id 4DCB6439-B0B2-4654-9040-B94AFADD054F@decibel.org
Whole thread Raw
In response to Effects of GUC settings on automatic replans  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses 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>)
List pgsql-hackers
Tree view 
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 by date:

Previous
From: Jim Nasby
Date:
Subject: Vacation
Next
From: Bruce Momjian
Date:
Subject: Re: Grouped Index Tuples / Clustered Indexes