pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: David Steele <david@pgmasters.net>
To: Andrey Lepikhov <a.lepikhov@postgrespro.ru>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: Removing unneeded self joins
Date: Wed, 1 Apr 2020 11:34:54 -0400
Message-ID: <031ab7da-c943-cd65-590e-671add024e3f@pgmasters.net> (raw)
In-Reply-To: <9315b1bc-f134-93aa-ed38-0d6a08719058@postgrespro.ru>
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>


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





view thread (247+ messages)  latest in thread

Message-ID: <031ab7da-c943-cd65-590e-671add024e3f@pgmasters.net>
Permalink:  ../031ab7da-c943-cd65-590e-671add024e3f@pgmasters.net/
Also on:    postgresql.org/message-id/031ab7da-c943-cd65-590e-671add024e3f@pgmasters.net

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: david@pgmasters.net, a.lepikhov@postgrespro.ru
  Subject: Re: Removing unneeded self joins
  In-Reply-To: <031ab7da-c943-cd65-590e-671add024e3f@pgmasters.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox