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 1111.1527977170@sss.pgh.pa.us
Whole thread Raw
In response to Re: why partition pruning doesn't work?  (Jeff Janes <jeff.janes@gmail.com>)
Responses Re: why partition pruning doesn't work?
List pgsql-hackers
Jeff Janes <jeff.janes@gmail.com> writes:
> On Fri, Jun 1, 2018 at 11:53 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> It's worth questioning whether this is a bug fix or an improvement.
>> If the latter, it probably ought to wait for v12.

> If explaining the change requires reference to tokens from the source code,
> rather than something an end user could understand, I'd argue it is a bug
> fix rather than an improvement.

Well, the difference between volatile, stable and immutable functions is
well-documented, so I don't think that's a great argument.  If there's
some aspect of this behavior that's not predictable from understanding
which class the partition key expression falls into, then I could agree
that's a bug.

            regards, tom lane


pgsql-hackers by date:

Previous
From: Ashutosh Bapat
Date:
Subject: Re: why partition pruning doesn't work?
Next
From: Amit Kapila
Date:
Subject: Few cosmetic suggestions for commit 16828d5c (Fast Alter Table Add Column...)