Memoize in between of two JOIN nodes
Andrei Lepikhov <lepihov@gmail.com>
From: Andrei Lepikhov <lepihov@gmail.com>
To: pgsql-bugs@lists.postgresql.org
Cc: Richard Guo <guofenglinux@gmail.com>
Date: 2025-03-06T11:17:22Z
Lists: pgsql-bugs
Attachments
- reproduction.sql (application/sql)
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? [1] https://www.postgresql.org/message-id/CAMbWs4_CQR9ikyAhjH0CwzCdp%2BFcRAeoVsi5Oohd7s%3Dc5RZABg%40mail.gmail.com -- regards, Andrei Lepikhov