| From: | Andrei Lepikhov <lepihov(at)gmail(dot)com> |
|---|---|
| To: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Alexander Korotkov <aekorotkov(at)gmail(dot)com> |
| Subject: | Correction of RowMark Removal During Sel-Join Elimination |
| Date: | 2025-08-01 12:32:51 |
| Message-ID: | 18c6bd6c-6d2a-419a-b0da-dfedef34b585@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
I've noticed that the code for sel-join elimination incorrectly removes
RowMarks. Currently, this doesn't lead to any issues because the
optimiser retains pointers to the simple_rte_array. A RowMark refers to
an RTE entry that is the same for both the relations being kept and
those being removed.
I believe it would be beneficial to address this issue now to prevent
potential problems in the future. See the patch attached.
--
regards, Andrei Lepikhov
| Attachment | Content-Type | Size |
|---|---|---|
| v0-0001-Force-RowMark-Sanity-Checking.patch | text/plain | 6.4 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2025-08-01 12:56:07 | Re: Add support for specifying tables in pg_createsubscriber. |
| Previous Message | Fujii Masao | 2025-08-01 11:55:10 | Re: Assertion failure in pgbench |