Re: Row pattern recognition

From: Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>
To: jchampion(at)timescale(dot)com, er(at)xs4all(dot)nl, vik(at)postgresfriends(dot)org
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Row pattern recognition
Date: 2023-09-22 05:16:40
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

> Attached is the fix against v6 patch. I will include this in upcoming v7 patch.

Attached is the v7 patch. It includes the fix mentioned above. Also
this time the pattern matching engine is enhanced: previously it
recursed to row direction, which means if the number of rows in a
frame is large, it could exceed the limit of stack depth. The new
version recurses over matched pattern variables in a row, which is at
most 26 which should be small enough.

Best reagards,
Tatsuo Ishii

Attachment Content-Type Size
v7-0001-Row-pattern-recognition-patch-for-raw-parser.patch text/x-patch 21.1 KB
v7-0002-Row-pattern-recognition-patch-parse-analysis.patch text/x-patch 11.6 KB
v7-0003-Row-pattern-recognition-patch-planner.patch text/x-patch 4.8 KB
v7-0004-Row-pattern-recognition-patch-executor.patch text/x-patch 35.4 KB
v7-0005-Row-pattern-recognition-patch-docs.patch text/x-patch 8.2 KB
v7-0006-Row-pattern-recognition-patch-tests.patch text/x-patch 35.3 KB
v7-0007-Allow-to-print-raw-parse-tree.patch text/x-patch 749 bytes

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2023-09-22 05:21:46 Re: Bug fix in vacuumdb --buffer-usage-limit xxx -Z
Previous Message Ryoga Yoshida 2023-09-22 05:11:14 Doesn't pgstat_report_wal() handle the argument "force" incorrectly