| From: | Peter Eisentraut <peter(at)eisentraut(dot)org> |
|---|---|
| To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
| Subject: | pgsql: Make generate_queries_for_path_pattern_recurse() interruptible |
| Date: | 2026-08-14 13:23:17 |
| Message-ID: | E1wursS-00000000YPu-1Wmw@gemulon.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
Make generate_queries_for_path_pattern_recurse() interruptible
In case of a very long path pattern with each element pattern being
resolved to many graph elements
generate_queries_for_path_pattern_recurse() may take very long time to
generate all the possible graph paths. Make
generate_queries_for_path_pattern_recurse() interruptible so that a
user may be able to cancel such a query if required and the interrupts
are processed in timely manner.
Author: Satyanarayana Narlapuram <satyanarlapuram(at)gmail(dot)com>
Reviewed-by: Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>
Discussion: https://www.postgresql.org/message-id/flat/CAHg%2BQDfDwcM4%3DDSiAV6Ly89YQ5EcMhzO1-9x%3DmGG1WJzODcAig%40mail.gmail.com
Branch
------
REL_19_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/41a300ae3df5015d0779728ee0b4adb866953d31
Modified Files
--------------
src/backend/rewrite/rewriteGraphTable.c | 2 ++
1 file changed, 2 insertions(+)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2026-08-14 16:14:42 | pgsql: psql: count every COPY FROM STDIN when scanning a query string. |
| Previous Message | Peter Eisentraut | 2026-08-14 11:54:49 | pgsql: Enforce WITH CHECK OPTION on DELETE FOR PORTION OF leftovers |