Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kk7Vb-0000pw-PL for pgsql-hackers@arkaria.postgresql.org; Tue, 01 Dec 2020 15:24:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kk7Va-0002jq-PU for pgsql-hackers@arkaria.postgresql.org; Tue, 01 Dec 2020 15:24:02 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kk7Va-0002jj-BS for pgsql-hackers@lists.postgresql.org; Tue, 01 Dec 2020 15:24:02 +0000 Received: from mail.postgrespro.ru ([93.174.131.139]) by makus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kk7VW-0007ab-Lw for pgsql-hackers@lists.postgresql.org; Tue, 01 Dec 2020 15:24:01 +0000 Received: from [192.168.1.70] (109-252-183-137.dynamic.spd-mgts.ru [109.252.183.137]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client did not present a certificate) by mail.postgrespro.ru (Postfix) with ESMTPSA id D96BF21C6F5E; Tue, 1 Dec 2020 18:23:55 +0300 (MSK) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=postgrespro.ru; s=mail; t=1606836236; bh=Bd+xE3bdL/4medfqZxN79blCMQH8IQoPPJVj2k+bdwQ=; h=Subject:To:Cc:References:From:Date:In-Reply-To; b=GCKnJyDvfNIHoawNjDrLtClArP+mu16k9fOfacsaBicX7vnjHvf50H3yuFwiIIP5y DcgrnqyenDh68Dq/rrHzcDhqgWIMN7h9PqmdZoKdBEMMslvqfKznU9km3ZeK0Yb6ZT svB92OeLBIlx/TfV7MFd1Hppka9WAayYKoipfTM8= Subject: Re: BUG #15383: Join Filter cost estimation problem in 10.5 To: "David G. Johnston" , Anastasia Lubennikova Cc: PostgreSQL Hackers , David Rowley References: <153683552113.22350.18441286362867559841@wrigleys.postgresql.org> <160407451328.1204.14768882331709534502.pgcf@coridan.postgresql.org> From: Anastasia Lubennikova Message-ID: <06456467-39c7-6605-b016-3c765d395a4f@postgrespro.ru> Date: Tue, 1 Dec 2020 18:23:55 +0300 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.10.0 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------4EC6D58448A16FC92A66D83B" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------4EC6D58448A16FC92A66D83B Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit On 30.10.2020 19:33, David G. Johnston wrote: > On Fri, Oct 30, 2020 at 9:16 AM Anastasia Lubennikova > > wrote: > > Status update for a commitfest entry. > > It looks like there was no real progress on this issue since > April. I see only an experimental patch. What kind of review does > it need right now? Do we need more testing or maybe production > statistics for such queries? > > David, are you going to continue working on it? > Can you, please, provide a short summary of the problem and list > open questions for reviewers. > > The new status of this patch is: Waiting on Author > > > I agree that updating a wiki seems like an unappealing conclusion to > this entry.  I'm on the fence whether we just leave it in the cf and > get a periodic nag when it gets bumped.  As we are describing real > problems or potential improvements to live portions of the codebase > ISTM that adding code comments near to those locations would be > warranted.  The commit message can reference this thread.  There seems > to already be a convention for annotating code comments in such a way > that they can be searched for - which basically is what sticking it in > the wiki would accomplish but the searcher would have to look in the > codebase and not on a website.  For the target audience of this > specific patch that seems quite reasonable. > > David J. > Here we are again. The commitfest is closed now and the discussion haven't moved from where it was a month ago. I don't see any use in moving it to the next CF as is and I don't want to return it either, as this is clearly a bug. I think we have a few options: 1. We can add it into TODO until better times. 2. We can write a patch to address this problem in code comments. 3. We can maybe CC this thread to someone and ask for help. Do you know people, who have  expertise in this area? None of these options is perfect, but the second option will perhaps be a good compromise. David, can you, please submit a patch? -- Anastasia Lubennikova Postgres Professional: http://www.postgrespro.com The Russian Postgres Company --------------4EC6D58448A16FC92A66D83B Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit
On 30.10.2020 19:33, David G. Johnston wrote:
On Fri, Oct 30, 2020 at 9:16 AM Anastasia Lubennikova <lubennikovaav@gmail.com> wrote:
Status update for a commitfest entry.

It looks like there was no real progress on this issue since April. I see only an experimental patch. What kind of review does it need right now? Do we need more testing or maybe production statistics for such queries?

David, are you going to continue working on it?
Can you, please, provide a short summary of the problem and list open questions for reviewers.

The new status of this patch is: Waiting on Author

I agree that updating a wiki seems like an unappealing conclusion to this entry.  I'm on the fence whether we just leave it in the cf and get a periodic nag when it gets bumped.  As we are describing real problems or potential improvements to live portions of the codebase ISTM that adding code comments near to those locations would be warranted.  The commit message can reference this thread.  There seems to already be a convention for annotating code comments in such a way that they can be searched for - which basically is what sticking it in the wiki would accomplish but the searcher would have to look in the codebase and not on a website.  For the target audience of this specific patch that seems quite reasonable.

David J.

Here we are again.
The commitfest is closed now and the discussion haven't moved from where it was a month ago.
I don't see any use in moving it to the next CF as is and I don't want to return it either, as this is clearly a bug.

I think we have a few options:

1. We can add it into TODO until better times.
2. We can write a patch to address this problem in code comments.
3. We can maybe CC this thread to someone and ask for help. Do you know people, who have  expertise in this area?

None of these options is perfect, but the second option will perhaps be a good compromise.
David, can you, please submit a patch?

-- 
Anastasia Lubennikova
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
--------------4EC6D58448A16FC92A66D83B--