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: (view raw or whole 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      512.569.9461 (cell)

In response to


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-2015 The PostgreSQL Global Development Group