| 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 |
| Date: | 2023-09-12 11:49:05 |
| Message-ID: | 05469e80-454b-41d7-d04f-421f42bbd4a9@postgrespro.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 5/7/2023 21:28, Andrey Lepikhov wrote:
> Hi,
>
> 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.
--
regards,
Andrey Lepikhov
Postgres Professional
| Attachment | Content-Type | Size |
|---|---|---|
| v43-0001-Remove-self-joins.patch | text/plain | 96.6 KB |
| From | Date | Subject | |
|---|---|---|---|
| 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 |