Hi David:
On Mon, Mar 8, 2021 at 9:34 AM David Rowley wrote:
> On Thu, 4 Mar 2021 at 22:07, Amit Langote wrote:
> > * Or maybe have you considered generalizing what
> > build_implied_pruning_quals() does so that other places like
> > indxpath.c can use the facility?
>
> I agree with doing it an
On Thu, 4 Mar 2021 at 22:07, Amit Langote wrote:
> * Or maybe have you considered generalizing what
> build_implied_pruning_quals() does so that other places like
> indxpath.c can use the facility?
I agree with doing it another way. There's plenty of other queries
which we could produce a better
Hi Amit:
Thanks for your review!
On Thu, Mar 4, 2021 at 5:07 PM Amit Langote wrote:
> Hi Andy,
>
> On Sun, Jan 24, 2021 at 7:34 PM Andy Fan wrote:
> > I recently found a use case like this. SELECT * FROM p, q WHERE
> p.partkey =
> > q.colx AND (q.colx = $1 OR q.colx = $2); Then we can't do
Hi Andy,
On Sun, Jan 24, 2021 at 7:34 PM Andy Fan wrote:
> I recently found a use case like this. SELECT * FROM p, q WHERE p.partkey =
> q.colx AND (q.colx = $1 OR q.colx = $2); Then we can't do either planning
> time
> partition prune or init partition prune. Even though we have run-time
>
On Fri, Feb 19, 2021 at 6:03 PM Andy Fan wrote:
>
>
> On Mon, Feb 8, 2021 at 3:43 PM Andy Fan wrote:
>
>>
>>
>> On Mon, Jan 25, 2021 at 10:21 AM Andy Fan
>> wrote:
>>
>>>
>>>
>>> On Sun, Jan 24, 2021 at 6:34 PM Andy Fan
>>> wrote:
>>>
Hi:
I recently found a use case like this.
On Mon, Feb 8, 2021 at 3:43 PM Andy Fan wrote:
>
>
> On Mon, Jan 25, 2021 at 10:21 AM Andy Fan
> wrote:
>
>>
>>
>> On Sun, Jan 24, 2021 at 6:34 PM Andy Fan
>> wrote:
>>
>>> Hi:
>>>
>>> I recently found a use case like this. SELECT * FROM p, q WHERE
>>> p.partkey =
>>> q.colx AND (q.colx = $1
On Mon, Jan 25, 2021 at 10:21 AM Andy Fan wrote:
>
>
> On Sun, Jan 24, 2021 at 6:34 PM Andy Fan wrote:
>
>> Hi:
>>
>> I recently found a use case like this. SELECT * FROM p, q WHERE
>> p.partkey =
>> q.colx AND (q.colx = $1 OR q.colx = $2); Then we can't do either
>> planning time
>> partiti
On Sun, Jan 24, 2021 at 6:34 PM Andy Fan wrote:
> Hi:
>
> I recently found a use case like this. SELECT * FROM p, q WHERE
> p.partkey =
> q.colx AND (q.colx = $1 OR q.colx = $2); Then we can't do either planning
> time
> partition prune or init partition prune. Even though we have run-time
>
Hi:
I recently found a use case like this. SELECT * FROM p, q WHERE p.partkey
=
q.colx AND (q.colx = $1 OR q.colx = $2); Then we can't do either planning
time
partition prune or init partition prune. Even though we have run-time
partition pruning work at last, it is too late in some cases si
