Re: Removing unneeded self joins

From: Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>
To: David Steele <david(at)pgmasters(dot)net>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Removing unneeded self joins
Date: 2020-04-03 04:43:41
Message-ID: 8a427a9a-50cd-51e9-3c1c-2176eceb39b0@postgrespro.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 4/1/20 8:34 PM, David Steele wrote:
> 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.

v.23 in attachment:

1. The patch applies cleanly.
2. Add checks: two potentially self joined relations may belong to
different rules of order restriction in join_info_list.
3. Add test for item 2.

The CF entry has been updated to Needs review.

--
Andrey Lepikhov
Postgres Professional
https://postgrespro.com
The Russian Postgres Company

Attachment Content-Type Size
0001-Remove-Self-Joins-v.23.patch text/x-patch 79.7 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Masahiko Sawada 2020-04-03 05:00:42 Re: Some problems of recovery conflict wait events
Previous Message Amit Kapila 2020-04-03 04:10:34 Re: WAL usage calculation patch