| From: | Tatsuo Ishii <ishii(at)postgresql(dot)org> |
|---|---|
| To: | sjjang112233(at)gmail(dot)com |
| Cc: | assam258(at)gmail(dot)com, vik(at)postgresfriends(dot)org, er(at)xs4all(dot)nl, jacob(dot)champion(at)enterprisedb(dot)com, david(dot)g(dot)johnston(at)gmail(dot)com, peter(at)eisentraut(dot)org, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Row pattern recognition |
| Date: | 2026-03-11 10:11:17 |
| Message-ID: | 20260311.191117.172824867943979935.ishii@postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi SungJun,
> Hi hackers,
>
> I ran a cross-validation test comparing PostgreSQL RPR (current patch) and
> Trino MATCH_RECOGNIZE to verify both result correctness and performance
> characteristics across different scales.
Thank you for the excellent report! I am glad to see that PostgreSQL
RPR is much faster than Trino, especially in the match failure cases.
Is it possible to share the data generation script and the query for
PostgreSQL so that I could locally perform the tests?
Best regards,
--
Tatsuo Ishii
SRA OSS K.K.
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ashutosh Sharma | 2026-03-11 10:22:25 | Re: synchronized_standby_slots behavior inconsistent with quorum-based synchronous replication |
| Previous Message | vignesh C | 2026-03-11 10:07:36 | Re: Skipping schema changes in publication |