Re: Re: NOT IN subquery optimization

From: David Steele <david(at)pgmasters(dot)net>
To: David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Li, Zheng" <zhelli(at)amazon(dot)com>, "Finnerty, Jim" <jfinnert(at)amazon(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Re: NOT IN subquery optimization
Date: 2019-03-05 08:21:32
Message-ID: 724a701a-404f-7c7a-e658-90d1ca1c0862@pgmasters.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2/27/19 2:26 AM, David Rowley wrote:
> On Wed, 27 Feb 2019 at 13:13, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>>
>> "Li, Zheng" <zhelli(at)amazon(dot)com> writes:
>>> However, given that the March CommitFest is imminent and the runtime smarts patent concerns David had pointed out (which I was not aware of before), we would not move that direction at the moment.
>>
>>> I propose that we collaborate to build one patch from the two patches submitted in this thread for the CF.
>>
>> TBH, I think it's very unlikely that any patch for this will be seriously
>> considered for commit in v12. It would be against project policy, and
>> spending a lot of time reviewing the patch would be quite unfair to other
>> patches that have been in the queue longer. Therefore, I'd suggest that
>> you not bend things out of shape just to have some patch to submit before
>> March 1. It'd be better to work with the goal of having a coherent patch
>> ready for the first v13 CF, probably July-ish.
>
> FWIW, I did add this to the March CF, but I set the target version to
> 13. I wasn't considering this for PG12. I see Zheng was, but I agree
> with you on PG13 being the target for this.

Looks like the target version of 13 was removed but I have added it back.

Regards,
--
-David
david(at)pgmasters(dot)net

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Steele 2019-03-05 08:29:42 Re: Re: [HACKERS] CLUSTER command progress monitor
Previous Message Etsuro Fujita 2019-03-05 08:11:18 Re: Problems with plan estimates in postgres_fdw