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
Message-ID: 20230922.141640.288673971790249857.t-ishii@sranhm.sra.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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
SRA OSS LLC
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp

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

Responses

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