git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 3fd19a9) | patch
Attempt to stabilize new window agg regression test
Fri, 4 Aug 2023 01:27:19 +0000 (13:27 +1200)
Fri, 4 Aug 2023 01:27:19 +0000 (13:27 +1200)
commit 7516056c584e3f7e04269f2e80835d1433e869c4
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
src/test/regress/expected/window.out diff | blob | blame | history
src/test/regress/sql/window.sql diff | blob | blame | history
This is the main PostgreSQL git repository.
RSS Atom

AltStyle によって変換されたページ (->オリジナル) /