pg.ddx.io pgsql-committers@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pgsql: Make generate_queries_for_path_pattern_recurse() interruptible 2+ messages / 1 participants [nested] [flat]
* pgsql: Make generate_queries_for_path_pattern_recurse() interruptible @ 2026-08-14 13:23 Peter Eisentraut <peter@eisentraut.org> 0 siblings, 0 replies; 2+ messages in thread From: Peter Eisentraut @ 2026-08-14 13:23 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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@gmail.com> Reviewed-by: Ashutosh Bapat <ashutosh.bapat.oss@gmail.com> Discussion: https://www.postgresql.org/message-id/flat/CAHg%2BQDfDwcM4%3DDSiAV6Ly89YQ5EcMhzO1-9x%3DmGG1WJzODcAig... 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(+) ^ permalink raw reply [nested|flat] 2+ messages in thread
* pgsql: Make generate_queries_for_path_pattern_recurse() interruptible @ 2026-08-14 13:23 Peter Eisentraut <peter@eisentraut.org> 0 siblings, 0 replies; 2+ messages in thread From: Peter Eisentraut @ 2026-08-14 13:23 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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@gmail.com> Reviewed-by: Ashutosh Bapat <ashutosh.bapat.oss@gmail.com> Discussion: https://www.postgresql.org/message-id/flat/CAHg%2BQDfDwcM4%3DDSiAV6Ly89YQ5EcMhzO1-9x%3DmGG1WJzODcAig... Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/a82e33a83d7cd39f3abd18c7b941625ca78d4c35 Modified Files -------------- src/backend/rewrite/rewriteGraphTable.c | 2 ++ 1 file changed, 2 insertions(+) ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2026-08-14 13:23 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2026-08-14 13:23 pgsql: Make generate_queries_for_path_pattern_recurse() interruptible Peter Eisentraut <peter@eisentraut.org> 2026-08-14 13:23 pgsql: Make generate_queries_for_path_pattern_recurse() interruptible Peter Eisentraut <peter@eisentraut.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox