Re: Removing unneeded self joins

From: Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>
To: Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>, 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-11-05 18:20:28
Message-ID: f84b7d25-d99c-5dd8-c9cb-64a3731a3e2a@postgrespro.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

v.21 in attechment fix small bug:
Now we move all non-mergejoinable clauses from joininfo to base restrict
info because of the relation will not be joined.

On 30/09/2019 13:29, Konstantin Knizhnik wrote:
>
> Slightly refactored version of the patch with more comments.
>

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

Attachment Content-Type Size
0001-Remove-self-joins-v21.patch text/x-patch 74.6 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Vik Fearing 2019-11-05 18:32:09 Re: Standard-conforming datetime years parsing
Previous Message Tom Lane 2019-11-05 17:22:21 Re: PostgreSQL 12 installation fails because locale name contained non-english characters