Re: Effects of GUC settings on automatic replans

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jan Wieck <JanWieck(at)Yahoo(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Effects of GUC settings on automatic replans
Date: 2007-03-21 17:46:12
Message-ID: 12482.1174499172@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Jan Wieck <JanWieck(at)Yahoo(dot)com> writes:
> On 3/20/2007 1:11 PM, Tom Lane wrote:
>> search_path
>> add_missing_from
>> transform_null_equals
>> sql_inheritance

> Don't we actually store the parsetree in the query cache, and doesn't
> that actually make a lot of the above rather NOT affect the resulting
> plan any more?

No, what the code now does is to store the raw grammar output --- a
replan includes a fresh pass through parse_analyze. This must happen
if we want the thing to cope with dropping and replacing temp tables,
which is one of the main use-cases ...

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavan Deolasee 2007-03-21 17:51:11 Re: CREATE INDEX and HOT - revised design
Previous Message Pavan Deolasee 2007-03-21 17:45:20 Re: CREATE INDEX and HOT - revised design