From: | Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp> |
---|---|
To: | champion(dot)p(at)gmail(dot)com |
Cc: | er(at)xs4all(dot)nl, vik(at)postgresfriends(dot)org, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Row pattern recognition |
Date: | 2023-10-25 02:49:30 |
Message-ID: | 20231025.114930.112660243012560194.t-ishii@sranhm.sra.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> Great. I will look into this.
I am impressed the simple NFA implementation. It would be nicer if it
could be implemented without using recursion.
> By the way, I tested my patch (v10) to handle more large data set and
> tried to following query with pgbench database. On my laptop it works
> with 100k rows pgbench_accounts table but with beyond the number I got
~~~ I meant 10k.
> OOM killer. I would like to enhance this in the next patch.
>
> SELECT aid, first_value(aid) OVER w,
> count(*) OVER w
> FROM pgbench_accounts
> WINDOW w AS (
> PARTITION BY bid
> ORDER BY aid
> ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING
> AFTER MATCH SKIP PAST LAST ROW
> INITIAL
> PATTERN (START UP+)
> DEFINE
> START AS TRUE,
> UP AS aid > PREV(aid)
> );
I ran this against your patch. It failed around > 60k rows.
Best reagards,
--
Tatsuo Ishii
SRA OSS LLC
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp
From | Date | Subject | |
---|---|---|---|
Next Message | David Rowley | 2023-10-25 02:55:22 | Re: Add new for_each macros for iterating over a List that do not require ListCell pointer |
Previous Message | David E. Wheeler | 2023-10-25 02:36:24 | Re: Patch: Improve Boolean Predicate JSON Path Docs |