Re: Row pattern recognition - Mailing list pgsql-hackers

From Henson Choi
Subject Re: Row pattern recognition
Date
Msg-id CAAAe_zD_5-PgEKZOuYt=9CQ9rH_x4pUy9rubfxDwUgTE=_EGkg@mail.gmail.com
Whole thread Raw
In response to Re: Row pattern recognition  (Jacob Champion <jacob.champion@enterprisedb.com>)
List 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 

pgsql-hackers by date:

Previous
From: wenhui qiu
Date:
Subject: Re: Planner : anti-join on left joins
Next
From: Henson Choi
Date:
Subject: Re: Row pattern recognition