postgres.git / summary / log / commit / refs
commit c048cd992c69ed20acbd9059763735e51781e95a
Author: David Rowley <drowley@postgresql.org>
Date: Tue Jul 09 00:46:48 2024 +0000
First released in: 18.0
Avoid JIT-related test instability in EXPLAIN ANALYZE
036bdcec9 added some code to perform some verification on portions of
the planner costs in EXPLAIN ANALYZE but failed to consider that some
buildfarm animals such as bushmaster and taipan are running very low jit
thresholds. This caused these animals to fail as they were outputting
JIT-related details in EXPLAIN ANALYZE for the newly added tests.
Here we avoid that by disabling JIT for the plans in question.
Discussion: https://postgr.es/m/CAApHDvpxV4rrO3XUCgGS5N9Wg6f2r0ojJPD2tX2FRV-o9sRTJA@mail.gmail.com
src/test/regress/expected/misc_functions.out | 3 +++
src/test/regress/sql/misc_functions.sql | 3 +++
2 files changed, 6 insertions(+)
diff --git a/src/test/regress/expected/misc_functions.out b/src/test/regress/expected/misc_functions.out
index 78c91eff013..35fb72f302b 100644
--- a/src/test/regress/expected/misc_functions.out
+++ b/src/test/regress/expected/misc_functions.out
@@ -18,6 +18,9 @@ BEGIN
analyze_str := 'off';
END IF;
+ -- avoid jit related output by disabling it
+ SET LOCAL jit = 0;
+
FOR ln IN
EXECUTE format('explain (analyze %s, costs on, summary off, timing off) %s',
analyze_str, query)
diff --git a/src/test/regress/sql/misc_functions.sql b/src/test/regress/sql/misc_functions.sql
index f30387f54ab..e570783453c 100644
--- a/src/test/regress/sql/misc_functions.sql
+++ b/src/test/regress/sql/misc_functions.sql
@@ -20,6 +20,9 @@ BEGIN
analyze_str := 'off';
END IF;
+ -- avoid jit related output by disabling it
+ SET LOCAL jit = 0;
+
FOR ln IN
EXECUTE format('explain (analyze %s, costs on, summary off, timing off) %s',
analyze_str, query)
[parent: c8d5d6c78af4]