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 <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1jJfOM-0004Tv-Fa
	for pgsql-hackers@arkaria.postgresql.org; Wed, 01 Apr 2020 15:34:58 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1jJfOL-0001la-DA
	for pgsql-hackers@arkaria.postgresql.org; Wed, 01 Apr 2020 15:34:57 +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 <david@pgmasters.net>)
	id 1jJfOL-0001lS-64
	for pgsql-hackers@lists.postgresql.org; Wed, 01 Apr 2020 15:34:57 +0000
Received: from mail.thelabyrinth.net ([45.56.70.56])
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <david@pgmasters.net>)
	id 1jJfOJ-0005y6-1F
	for pgsql-hackers@postgresql.org; Wed, 01 Apr 2020 15:34:56 +0000
Received: from Davids-MacBook-Pro.local (c-73-39-102-148.hsd1.va.comcast.net
 [73.39.102.148])
	(using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits))
	(No client certificate requested)
	(Authenticated sender: dsteele)
	by mail.thelabyrinth.net (Postfix) with ESMTPSA id A124854692;
	Wed,  1 Apr 2020 15:34:54 +0000 (UTC)
Subject: Re: Removing unneeded self joins
To: Andrey Lepikhov <a.lepikhov@postgrespro.ru>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
References: <64486b0b-0404-e39e-322d-0801154901f3@postgrespro.ru>
 <552e481b-2feb-75fd-4e9f-4199bfd1c1f3@postgrespro.ru>
 <CAKJS1f8p-KiEujr12k-oa52JNWWaQUjEjNg+o1MGZk4mHBn_Rg@mail.gmail.com>
 <31c2ee33-5db1-a43c-b964-8e2624020ae9@postgrespro.ru>
 <CAKJS1f_cPDTRBTW4KpuD5fktVjPs2ugg704CJn=OxWXoUv-rDw@mail.gmail.com>
 <CAKJS1f8cJOCGyoxi7a_LG7eu+WKF9+HTff3wp1KKS5gcUg2Qfg@mail.gmail.com>
 <89c8a17d-01f8-a03d-7fb8-0a8a070be47c@postgrespro.ru>
 <fa5ce779-2200-702f-85ec-780f1769cd66@postgrespro.ru>
 <9b226ea2-bce0-90b2-9909-7964b7f353f7@postgrespro.ru>
 <8556348d-b5fa-728a-e4db-8dcad9d11e4b@postgrespro.ru>
 <CA+hUKGK_gpPm4AN7rV0RUvdFus=V_P_7DEVErRfMdeQt4Zr3vA@mail.gmail.com>
 <9aa6421b-fa8c-b578-6f18-0174c51f0884@postgrespro.ru>
 <bfcdcf79-d726-3986-597e-bbd9b68a67cc@postgrespro.ru>
 <2c08741c-3d58-f517-23de-549d6c15e14e@postgrespro.ru>
 <cd839807-fc9e-9028-a132-a70631a1edbf@postgrespro.ru>
 <f84b7d25-d99c-5dd8-c9cb-64a3731a3e2a@postgrespro.ru>
 <9315b1bc-f134-93aa-ed38-0d6a08719058@postgrespro.ru>
From: David Steele <david@pgmasters.net>
Message-ID: <031ab7da-c943-cd65-590e-671add024e3f@pgmasters.net>
Date: Wed, 1 Apr 2020 11:34:54 -0400
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:68.0)
 Gecko/20100101 Thunderbird/68.6.0
MIME-Version: 1.0
In-Reply-To: <9315b1bc-f134-93aa-ed38-0d6a08719058@postgrespro.ru>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 7bit
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Precedence: bulk


On 1/27/20 11:10 PM, Andrey Lepikhov wrote:
> Rebased version v.22.
> - Added enable_self_join_removal GUC (true is default)
> - The joinquals of the relation that is being removed, redistributed in 
> accordance with the remove_rel_from_query () machinery.

This patch no longer applies cleanly on 
src/test/regress/sql/equivclass.sql: 
http://cfbot.cputube.org/patch_27_1712.log

The CF entry has been updated to Waiting on Author.

Regards,
-- 
-David
david@pgmasters.net