commit - 80d690721973f6a031143a24a34b78a0225101a2 SQL repro script ================ CREATE EXTENSION IF NOT EXISTS pg_trgm; set statement_timeout = '1s'; show statement_timeout; \timing on select 1 where repeat('1.1',80000) %>> 'Lorem ipsum dolor sit amet';SELECT 1; -- Check whether this change brought in any performance regressions set statement_timeout='0'; show statement_timeout; select COUNT(*) from generate_series(1,1) q(e) where repeat('1.1',10000) %>> ('Lorem ipsum dolor sit amet'||e::text); select COUNT(*) from generate_series(1,10) q(e) where repeat('1.1',10000) %>> ('Lorem ipsum dolor sit amet'||e::text); select COUNT(*) from generate_series(1,100) q(e) where repeat('1.1',10000) %>> ('Lorem ipsum dolor sit amet'||e::text); SQL script output ================= CREATE EXTENSION SET statement_timeout ------------------- 1s (1 row) Timing is on. ?column? ---------- (0 rows) Time: 29620.933 ms (00:29.621) psql:/home/ubuntu/proj/sqlsmithdata/repro1.sql:11: ERROR: canceling statement due to statement timeout Time: 0.073 ms SET Time: 0.159 ms statement_timeout ------------------- 0 (1 row) Time: 0.100 ms count ------- 0 (1 row) Time: 473.449 ms count ------- 0 (1 row) Time: 4725.483 ms (00:04.725) count ------- 0 (1 row) Time: 47222.223 ms (00:47.222)