as_of_80d690721973f6a031143a24a34b78a0225101a2.txt

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)