Skip site navigation (1) Skip section navigation (2)

Re: Effects of GUC settings on automatic replans

From: Jim Nasby <decibel(at)decibel(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: Effects of GUC settings on automatic replans
Date: 2007-03-24 17:20:35
Message-ID: 4DCB6439-B0B2-4654-9040-B94AFADD054F@decibel.org (view raw or flat)
Thread:
Lists: 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(at)nasby(dot)net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)



In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2007-03-24 18:00:30
Subject: Idea for cleaner representation of snapshots
Previous:From: Jim NasbyDate: 2007-03-24 17:12:25
Subject: Vacation

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group