summaryrefslogtreecommitdiff
path: root/src/backend/postmaster/checkpointer.c
diff options
context:
space:
mode:
authorMichael Paquier <michael@paquier.xyz>2019-08-13 10:55:19 +0900
committerMichael Paquier <michael@paquier.xyz>2019-08-13 10:55:19 +0900
commit2d7d67cc74d0f59e76464bd5009bc74f1591018e (patch)
tree90bb62295872b0046cc2a44754b61da39062a5af /src/backend/postmaster/checkpointer.c
parent6754fe65a4c68c1e3b179080ab62c2f3ff6d877c (diff)
downloadpostgresql-2d7d67cc74d0f59e76464bd5009bc74f1591018e.tar.gz
Fix random regression failure in test case "temp"
This test case could fail because of an incorrect result ordering when looking up at pg_class entries. This commit adds an ORDER BY to the culprit query. The cause of the failure was likely caused by a plan switch. By default, the planner would likely choose an index-only scan or an index scan, but even a small change in the startup cost could have caused a bitmap heap scan to be chosen, causing the failure. While on it, switch some filtering quals to a regular expression as per an idea of Tom Lane. As previously shaped, the quals would have selected any relations whose name begins with "temp". And that could cause failures if another test running in parallel began to use similar relation names. Per report from buildfarm member anole, though the failure was very rare. This test has been introduced by 319a810, so backpatch down to v10. Discussion: https://postgr.es/m/20190807132422.GC15695@paquier.xyz Backpatch-through: 10
Diffstat (limited to 'src/backend/postmaster/checkpointer.c')
0 files changed, 0 insertions, 0 deletions