| From: | Richard Guo <guofenglinux(at)gmail(dot)com> |
|---|---|
| To: | Alexandra Wang <alexandra(dot)wang(dot)oss(at)gmail(dot)com> |
| Cc: | Álvaro Herrera <alvherre(at)kurilemu(dot)de>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Andy Fan <zhihuifan1213(at)163(dot)com>, wenhui qiu <qiuwenhuifx(at)gmail(dot)com> |
| Subject: | Re: Pathify RHS unique-ification for semijoin planning |
| Date: | 2025-08-04 02:08:08 |
| Message-ID: | CAMbWs48nbQ+7ioTid6KXavBiH-UKXpp4nEH0+PRFYdKQp0gB-Q@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
The v5 patch does not apply anymore, and here is a new rebase. There
are two main changes in v6:
* I choose to use the check I proposed earlier to determine whether a
relation has been unique-ified in costsize.c.
* Now that the only call to relation_has_unique_index_for() that
supplied an exprlist and oprlist has been removed, the loop handling
those lists is effectively dead code. 0002 removes that loop and
simplifies the function accordingly.
Thanks
Richard
| Attachment | Content-Type | Size |
|---|---|---|
| v6-0001-Pathify-RHS-unique-ification-for-semijoin-plannin.patch | application/octet-stream | 107.3 KB |
| v6-0002-Simplify-relation_has_unique_index_for.patch | application/octet-stream | 7.3 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | torikoshia | 2025-08-04 02:18:20 | Re: [PATCH] Avoid unnecessary code execution in Instrument.c when TIMING is FALSE |
| Previous Message | Richard Guo | 2025-08-04 01:55:48 | Re: Pathify RHS unique-ification for semijoin planning |