pgsql: Check for interrupts in pg_trgm word similarity

From: Daniel Gustafsson <dgustafsson(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Check for interrupts in pg_trgm word similarity
Date: 2022-09-05 09:22:39
Message-ID: E1oV8JT-001XNj-43@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Check for interrupts in pg_trgm word similarity

Calculating similarity between large strings can be timesconsuming
and overrun configured statement timeouts. Check for interrupts in
the main loop to ensure query cancellation can be performed.

Author: Robins Tharakan <tharakan(at)gmail(dot)com>
Reviewed-by: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Discussion: https://postgr.es/m/CAEP4nAxvmfc_XWTz73bqXRhgjONi=1HaX4_NhsopA3L6UvnN1g@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/ae4fc52ae24785f51e3dc5a4c7e5b4d206356bdc

Modified Files
--------------
contrib/pg_trgm/trgm_op.c | 7 ++++++-
1 file changed, 6 insertions(+), 1 deletion(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Peter Eisentraut 2022-09-05 11:31:53 pgsql: Fix incorrect uses of Datum conversion macros
Previous Message David Rowley 2022-09-05 06:46:02 pgsql: Doc: clarify partitioned table limitations