pgsql: Attempt to stabilize new window agg regression test

From: David Rowley <drowley(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Attempt to stabilize new window agg regression test
Date: 2023-08-04 01:27:56
Message-ID: E1qRjbf-000L0T-Ii@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Attempt to stabilize new window agg regression test

This test was recently added in 3900a02c9. It appears to be unstable in
regards to the join order presumably due to the relations at either side
of the join being equal in side. Here we add a qual to make one of them
smaller so the planner is more likely to choose to hash the smaller of the
two.

Reported-by: Nathan Bossart, Tom Lane
Discussion: https://www.postgr.es/m/20230803235403.GC1238296@nathanxps13

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/7516056c584e3f7e04269f2e80835d1433e869c4

Modified Files
--------------
src/test/regress/expected/window.out | 10 ++++++----
src/test/regress/sql/window.sql | 1 +
2 files changed, 7 insertions(+), 4 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Amit Kapila 2023-08-04 03:03:52 pgsql: Simplify some of the logical replication worker-type checks.
Previous Message David Rowley 2023-08-03 22:48:10 pgsql: Minor adjustments to WindowAgg startup cost code