Re: Removing unneeded self joins

From: Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>
To: Thomas Munro <thomas(dot)munro(at)gmail(dot)com>
Cc: David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Arseny Sher <a(dot)sher(at)postgrespro(dot)ru>
Subject: Re: Removing unneeded self joins
Date: 2019-08-05 11:24:52
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On 02/08/2019 04:54, Thomas Munro wrote:
> On Thu, Jun 27, 2019 at 6:42 PM Andrey Lepikhov
> <a(dot)lepikhov(at)postgrespro(dot)ru> wrote:
>> Version v.17 of the patch that fix the bug see in attachment.
> While moving this to the September CF, I noticed that it needs to be
> updated for the recent pg_list.h API changes.
The patch was updated:
1. Changes caused by pg_list.h API changes.
2. Fix the problem of joint clause_relids and required_relids changes [1].
3. Add eclass mentions of removed relation into the kept relation (field
eclass_indexes was introduced by commit 3373c71553).


Andrey Lepikhov
Postgres Professional
The Russian Postgres Company

Attachment Content-Type Size
0001-Remove-self-joins-v18.patch text/x-patch 67.6 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Laurenz Albe 2019-08-05 11:30:43 Re: Identity columns should own only one sequence
Previous Message Laurenz Albe 2019-08-05 11:24:32 Re: Identity columns should own only one sequence