|From:||Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>|
|To:||"Gregory Stark (as CFM)" <stark(dot)cfm(at)gmail(dot)com>, Michał Kłeczek <michal(at)kleczek(dot)org>|
|Cc:||PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>|
|Subject:||Re: Removing unneeded self joins|
|Views:||Raw Message | Whole Thread | Download mbox | Resend email|
On 5/7/2023 21:28, Andrey Lepikhov wrote:
> During the significant code revision in v.41 I lost some replacement
> operations. Here is the fix and extra tests to check this in the future.
> Also, Tom added the JoinDomain structure five months ago, and I added
> code to replace relids for that place too.
> One more thing, I found out that we didn't replace SJs, defined by
> baserestrictinfos if no one self-join clause have existed for the join.
> Now, it is fixed, and the test has been added.
> To understand changes readily, see the delta file in the attachment.
Here is new patch in attachment. Rebased on current master and some
minor gaffes are fixed.
|Next Message||Hayato Kuroda (Fujitsu)||2023-09-12 11:50:22||RE: [PoC] pg_upgrade: allow to upgrade publisher node|
|Previous Message||Suraj Kharage||2023-09-12 09:57:21||Server crash on RHEL 9/s390x platform against PG16|