Re: why partition pruning doesn't work? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: why partition pruning doesn't work?
Date
Msg-id 10432.1528045900@sss.pgh.pa.us
Whole thread Raw
In response to Re: why partition pruning doesn't work?  (Dmitry Dolgov <9erthalion6@gmail.com>)
Responses Re: why partition pruning doesn't work?
List pgsql-hackers
Dmitry Dolgov <9erthalion6@gmail.com> writes:
> Just to clarify for myself, for evaluating any stable function here would it be
> enough to handle all function-like expressions (FuncExpr / OpExpr /
> DistinctExpr / NullIfExpr) and check a corresponding function for provolatile,
> like in the attached patch?

I think the entire approach is wrong here.  Rather than concerning
yourself with Params, or any other specific expression type, you
should be using !contain_volatile_functions() to decide whether
an expression is run-time-constant.  If it is, use the regular
expression evaluation machinery to extract the value.

            regards, tom lane


pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: csv format for psql
Next
From: "David G. Johnston"
Date:
Subject: Re: csv format for psql