| From: | Andrei Lepikhov <lepihov(at)gmail(dot)com> | 
|---|---|
| To: | pgsql-bugs(at)lists(dot)postgresql(dot)org | 
| Cc: | Richard Guo <guofenglinux(at)gmail(dot)com> | 
| Subject: | Memoize in between of two JOIN nodes | 
| Date: | 2025-03-06 11:17:22 | 
| Message-ID: | 531bcdbc-e734-4db8-b1d1-18af8bdf9eab@gmail.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-bugs | 
Playing with memoisation, I found the case where the Memoize is put over 
a JOIN node (see attachment).
I recall a discussion we had with Richard in which he mentioned [1] that 
this feature is still not implemented and is hard to design.
I'm not sure, but may it be a sign of a potential bug?
-- 
regards, Andrei Lepikhov
| Attachment | Content-Type | Size | 
|---|---|---|
| reproduction.sql | application/sql | 1.8 KB | 
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nico Williams | 2025-03-06 16:50:37 | Re: BUG #18825: Row value equality predicates do not use indices | 
| Previous Message | PG Bug reporting form | 2025-03-06 10:16:12 | BUG #18833: libpq.so doesn't contain declared symbol in rpm --provides |