| From: | ZizhuanLiu X-MAN <44973863(at)qq(dot)com> |
|---|---|
| To: | pgsql-hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Cc: | jian he <jian(dot)universality(at)gmail(dot)com>, tgl <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Guo <rguo(at)postgresql(dot)org> |
| Subject: | Re: examine_variable ignored CollateExpr |
| Date: | 2026-08-18 12:49:18 |
| Message-ID: | tencent_B0C5274ABEC12DE7A9DD1A6BE077DBD86809@qq.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi hackers,
Upon further consideration, in the newly added function strip_all_adjacency_relabeltypes_walker,
when handling adjacent RelabelType nodes, besides performance and memory space related
optimizations, we should also follow the behavior of applyRelabelType() and perform analogous
processing on the RelabelType’s argument.
The resulting expression yields an equivalent simple Var, which can be used to look up column statistics,
and also works correctly for equal() comparisons against index expressions and extended statistics expressions.
The test SQL and scenarios remain the same as in my previous mail.
regards,
--
ZizhuanLiu (X-MAN)
44973863(at)qq(dot)com
| Attachment | Content-Type | Size |
|---|---|---|
| v4-0001-proper-handling-examine_variable-RelabelType.patch | application/octet-stream | 4.6 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amit Langote | 2026-08-18 12:51:14 | Re: InvalidateConstraintCacheCallBack() can free fpmeta while it's in use |
| Previous Message | Daniel Gustafsson | 2026-08-18 12:42:17 | Re: basebackup: do not verify checksums on pages written before enabling checksums |