| From: | Henson Choi <assam258(at)gmail(dot)com> |
|---|---|
| To: | Jacob Champion <jacob(dot)champion(at)enterprisedb(dot)com> |
| Cc: | Tatsuo Ishii <ishii(at)postgresql(dot)org>, david(dot)g(dot)johnston(at)gmail(dot)com, vik(at)postgresfriends(dot)org, er(at)xs4all(dot)nl, peter(at)eisentraut(dot)org, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Row pattern recognition |
| Date: | 2026-01-10 09:20:16 |
| Message-ID: | CAAAe_zD_5-PgEKZOuYt=9CQ9rH_x4pUy9rubfxDwUgTE=_EGkg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
>
> Neat! In case it helps, you may also be interested in my (now very out
> of date) mails at [1] and [2].
>
Thanks for the pointers! I'll definitely dig into those threads.
> At one point I was also working on an independent implementation of
> the preferment rules, to make it easier for developers to intuit how
> matches were made, but I can't find that email at the moment. This may
> have some overlap with "state visualization" for the engine? I have a
> 3k-line patch based on top of v22 of the patchset as of September
> 2024, if there is interest in that, but no promises on quality -- I
> would have posted it if I thought it was ready for review :D
>
I'd definitely be interested in seeing it, rough edges and all. I haven't
tackled the PostgreSQL integration design yet, so understanding how
preferment rules map to the existing infrastructure would be very helpful.
(Tatsuo found that email, by the way.)
>
> Thanks,
> --Jacob
>
> [1]
> https://postgr.es/m/96b4d3c8-1415-04db-5629-d2617ac7a156%40timescale.com
> [2]
> https://postgr.es/m/CAGu%3Du8gcyAQAsDLp-01R21%3DM4bpAiGP9PZz0OyiMo5_bM30PMA%40mail.gmail.com
Best regards,
Henson
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Henson Choi | 2026-01-10 09:42:40 | Re: Row pattern recognition |
| Previous Message | wenhui qiu | 2026-01-10 09:13:28 | Re: Planner : anti-join on left joins |