Implement row pattern recognition feature

Edit

ID 4460

Title Implement row pattern recognition feature

Topic SQL Commands

Created 2023-07-26 12:28:19

Last modified 2025-02-03 12:20:34 (1 week, 4 days ago)

Latest email 2025-01-11 05:46:11 (1 month ago)

Status

2025-03: Needs review

2025-01: Moved to next CF

2024-11: Moved to next CF

2024-09: Moved to next CF

2024-07: Moved to next CF

2024-03: Moved to next CF

2024-01: Moved to next CF

2023-11: Moved to next CF

2023-09: Moved to next CF

Target version 18

Authors Tatsuo Ishii (ishii)

Reviewers Vik Fearing (xocolatl), Jacob Champion (jchampion), Ningwei Chen (chen-5033)Become reviewer

Committer

Links CFbot results (CirrusCI) CFbot GitHub

Checkout latest CFbot patchset

Go to your local checkout of the PostgreSQL repository and run:

git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/4460
git checkout commitfest/cf/4460

Emails

Row pattern recognition: First at 2023-06-25 12:05:09 by Tatsuo Ishii <ishii at sraoss.co.jp>
Latest at 2025-01-11 05:46:11 by Tatsuo Ishii <ishii at postgresql.org>
Latest attachment (v28-0001-Row-pattern-recognition-patch-for-raw-parser.patch) at 2025-01-11 05:46:11 from Tatsuo Ishii <ishii at postgresql.org>
    Attachment (v28-0001-Row-pattern-recognition-patch-for-raw-parser.patch) at 2025-01-11 05:46:11 from Tatsuo Ishii <ishii at postgresql.org> (Patch: Yes)
    Attachment (v27-0001-Row-pattern-recognition-patch-for-raw-parser.patch) at 2024-12-30 23:57:07 from Tatsuo Ishii <ishii at postgresql.org> (Patch: Yes)
    Attachment (v26-0001-Row-pattern-recognition-patch-for-raw-parser.patch) at 2024-12-30 13:37:18 from Tatsuo Ishii <ishii at postgresql.org> (Patch: Yes)
    Attachment (v25-0001-Row-pattern-recognition-patch-for-raw-parser.patch) at 2024-12-21 09:20:04 from Tatsuo Ishii <ishii at postgresql.org> (Patch: Yes)
    Attachment (v24-0001-Row-pattern-recognition-patch-for-raw-parser.patch) at 2024-12-19 06:19:50 from Tatsuo Ishii <ishii at postgresql.org> (Patch: Yes)
    Attachment (v23-0001-Row-pattern-recognition-patch-for-raw-parser.patch) at 2024-10-25 04:04:53 from Tatsuo Ishii <ishii at postgresql.org> (Patch: Yes)
    Attachment (unknown_filename) at 2024-09-28 10:43:59 from Tatsuo Ishii <ishii at postgresql.org> (Patch: Yes)
    Attachment (rpr-large-partitions.diff.txt) at 2024-09-27 22:27:07 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: Yes)
    Attachment (v22-0001-Row-pattern-recognition-patch-for-raw-parser.patch) at 2024-09-19 04:59:47 from Tatsuo Ishii <ishii at postgresql.org> (Patch: Yes)
    Attachment (v21-0001-Row-pattern-recognition-patch-for-raw-parser.patch) at 2024-08-26 04:39:47 from Tatsuo Ishii <ishii at postgresql.org> (Patch: Yes)
    Attachment (v20-0001-Row-pattern-recognition-patch-for-raw-parser.patch) at 2024-05-24 02:39:19 from Tatsuo Ishii <ishii at sraoss.co.jp> (Patch: Yes)
    Attachment (v19-0001-Row-pattern-recognition-patch-for-raw-parser.patch) at 2024-05-15 00:02:03 from Tatsuo Ishii <ishii at sraoss.co.jp> (Patch: Yes)
    Attachment (v18-0001-Row-pattern-recognition-patch-for-raw-parser.patch) at 2024-05-11 07:23:07 from Tatsuo Ishii <ishii at sraoss.co.jp> (Patch: Yes)
    Attachment (v17-0001-Row-pattern-recognition-patch-for-raw-parser.patch) at 2024-04-28 11:28:26 from Tatsuo Ishii <ishii at sraoss.co.jp> (Patch: Yes)
    Attachment (unknown_filename) at 2024-04-26 06:09:32 from Tatsuo Ishii <ishii at sraoss.co.jp> (Patch: Yes)
    Attachment (v16-0001-Row-pattern-recognition-patch-for-raw-parser.patch) at 2024-04-12 07:09:08 from Tatsuo Ishii <ishii at sraoss.co.jp> (Patch: Yes)
    Attachment (v15-0001-Row-pattern-recognition-patch-for-raw-parser.patch) at 2024-03-28 10:59:25 from Tatsuo Ishii <ishii at sraoss.co.jp> (Patch: Yes)
    Attachment (v14-0001-Row-pattern-recognition-patch-for-raw-parser.patch) at 2024-02-29 00:19:54 from Tatsuo Ishii <ishii at sraoss.co.jp> (Patch: Yes)
    Attachment (v13-0001-Row-pattern-recognition-patch-for-raw-parser.patch) at 2024-01-22 10:26:18 from Tatsuo Ishii <ishii at sraoss.co.jp> (Patch: Yes)
    Attachment (rewriter-patch.txt) at 2024-01-22 05:51:49 from NINGWEI CHEN <chen at sraoss.co.jp> (Patch: Yes)
    Attachment (unknown_filename) at 2023-12-08 22:22:58 from Tatsuo Ishii <ishii at sraoss.co.jp> (Patch: Yes)
    Attachment (v12-0001-Row-pattern-recognition-patch-for-raw-parser.patch) at 2023-12-08 01:16:13 from Tatsuo Ishii <ishii at sraoss.co.jp> (Patch: Yes)
    Attachment (v11-0001-Row-pattern-recognition-patch-for-raw-parser.patch) at 2023-11-08 07:37:05 from Tatsuo Ishii <ishii at sraoss.co.jp> (Patch: Yes)
    Attachment (recursive-backtrack.diff.txt) at 2023-10-24 18:51:19 from Jacob Champion <champion.p at gmail.com> (Patch: Yes)
    Attachment (v10-0001-Row-pattern-recognition-patch-for-raw-parser.patch) at 2023-10-22 02:39:20 from Tatsuo Ishii <ishii at sraoss.co.jp> (Patch: Yes)
    Attachment (v9-0001-Row-pattern-recognition-patch-for-raw-parser.patch) at 2023-10-04 06:03:28 from Tatsuo Ishii <ishii at sraoss.co.jp> (Patch: Yes)
    Attachment (v8-0001-Row-pattern-recognition-patch-for-raw-parser.patch) at 2023-09-25 05:26:30 from Tatsuo Ishii <ishii at sraoss.co.jp> (Patch: Yes)
    Attachment (regression.diffs) at 2023-09-22 08:26:49 from Erik Rijkers <er at xs4all.nl> (Patch: Yes)
    Attachment (regression.diffs) at 2023-09-22 08:12:38 from Erik Rijkers <er at xs4all.nl> (Patch: Yes)
    Attachment (v7-0001-Row-pattern-recognition-patch-for-raw-parser.patch) at 2023-09-22 05:16:40 from Tatsuo Ishii <ishii at sraoss.co.jp> (Patch: Yes)
    Attachment (v6-fix.patch) at 2023-09-12 08:44:57 from Tatsuo Ishii <ishii at sraoss.co.jp> (Patch: Yes)
    Attachment (v6-0001-Row-pattern-recognition-patch-for-raw-parser.patch) at 2023-09-12 06:18:43 from Tatsuo Ishii <ishii at sraoss.co.jp> (Patch: Yes)
    Attachment (test-last_value.diff.txt) at 2023-09-08 00:00:07 from Jacob Champion <jchampion at timescale.com> (Patch: Yes)
    Attachment (v5-0001-Row-pattern-recognition-patch-for-raw-parser.patch) at 2023-09-02 06:52:35 from Tatsuo Ishii <ishii at sraoss.co.jp> (Patch: Yes)
    Attachment (v4-0001-Row-pattern-recognition-patch-for-raw-parser.patch) at 2023-08-09 08:41:12 from Tatsuo Ishii <ishii at sraoss.co.jp> (Patch: Yes)
    Attachment (v3-0001-Row-pattern-recognition-patch-for-raw-parser.patch) at 2023-07-26 12:21:34 from Tatsuo Ishii <ishii at sraoss.co.jp> (Patch: Yes)
    Attachment (tests.diff.txt) at 2023-07-21 23:14:12 from Jacob Champion <jchampion at timescale.com> (Patch: Yes)
    Attachment (tests.diff.txt) at 2023-07-20 23:36:37 from Jacob Champion <jchampion at timescale.com> (Patch: Yes)
    Attachment (v2-0001-Row-pattern-recognition-patch-for-raw-parser.patch) at 2023-06-26 08:45:07 from Tatsuo Ishii <ishii at sraoss.co.jp> (Patch: Yes)
    Attachment (v1-0001-Row-pattern-recognition-patch-for-raw-parser.patch) at 2023-06-25 12:05:09 from Tatsuo Ishii <ishii at sraoss.co.jp> (Patch: Yes)

History

When	Who	What
2025-02-03 12:20:34	Tatsuo Ishii (ishii)	Closed in commitfest 2025-01 with status: Moved to next CF
2024-11-30 05:24:25	Kirill Reshke (reshke)	Closed in commitfest 2024-11 with status: Moved to next CF
2024-10-07 10:47:17	Tatsuo Ishii (ishii)	Closed in commitfest 2024-09 with status: Moved to next CF
2024-08-01 02:05:23	Corey Huinker (coreyh)	Closed in commitfest 2024-07 with status: Moved to next CF
2024-07-18 20:35:35	Tatsuo Ishii (ishii)	Changed targetversion to 18
2024-04-09 06:22:33	Andrey Borodin (x4m)	Closed in commitfest 2024-03 with status: Moved to next CF
2024-04-09 06:22:28	Andrey Borodin (x4m)	Changed targetversion to None
2024-02-07 07:02:48	Ningwei Chen (chen-5033)	Added chen-5033 as reviewer
2024-02-01 18:08:01	vigneshwaran C (vignesh.postgres)	Closed in commitfest 2024-01 with status: Moved to next CF
2023-12-04 10:17:16	John Naylor (john.naylor)	Closed in commitfest 2023-11 with status: Moved to next CF
2023-10-02 11:10:07	Peter Eisentraut (petere)	Closed in commitfest 2023-09 with status: Moved to next CF
2023-09-22 10:14:41	Tatsuo Ishii (ishii)	New status: Needs review
2023-09-04 22:58:53	Tatsuo Ishii (ishii)	New status: Waiting on Author
2023-07-26 12:30:14	Tatsuo Ishii (ishii)	Changed reviewers to Vik Fearing (xocolatl), Jacob Champion (jchampion)
2023-07-26 12:30:14	Tatsuo Ishii (ishii)	Changed authors to Tatsuo Ishii (ishii)
2023-07-26 12:30:14	Tatsuo Ishii (ishii)	Changed targetversion to 17
2023-07-26 12:28:19	Tatsuo Ishii (ishii)	Attached mail thread 20230625.210509.1276733411677577841.t-ishii@sranhm.sra.co.jp
2023-07-26 12:28:19	Tatsuo Ishii (ishii)	Created patch record

Edit