Re: Proposal: new GUC paramter - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Proposal: new GUC paramter
Date
Msg-id 29800.1001480977@sss.pgh.pa.us
Whole thread Raw
In response to Proposal: new GUC paramter  (Tatsuo Ishii <t-ishii@sra.co.jp>)
Responses Re: Proposal: new GUC paramter  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Tatsuo Ishii <t-ishii@sra.co.jp> writes:
> This is really annoying since:
> o these code fragments actually controls the optimization efforts for
>   subqueries and views, not related to GEQO at all. So using GEQO
>   parameters for this kind of purpose seems abuse for me.

But GEQO_RELS is directly related to the maximum number of FROM-clause
entries that we want to try to handle by exhaustive search.  So I think
it's not completely unreasonable to use it for this additional purpose.

Still, if you want to do the work to create another GUC parameter,
I won't object.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: tuple statistics function
Next
From: Thomas Lockhart
Date:
Subject: Re: Unicode combining characters