Set synchronous_commit=on in test_setup.sql.
Andres Freund <andres@anarazel.de>
Set synchronous_commit=on in test_setup.sql. Starting in cc50080a82 create_index test fails when run with synchronous_commit=off. synchronous_commit=off delays when hint bits may be set. Some plans change depending on the number of all-visible pages, which in turn can be influenced by the delayed hint bits. Force synchronous_commit to `on` in test_setup.sql. Not very satisfying, but there's no obvious alternative. Reported-By: Aleksander Alekseev <aleksander@timescale.com> Author: Andres Freund <andres@anarazel.de> Author: Aleksander Alekseev <aleksander@timescale.com> Discussion: https://www.postgresql.org/message-id/flat/CAJ7c6TPJNof1Q+vJsy3QebgbPgXdu2ErPvYkBdhD6_Ckv5EZRg@mail.gmail.com
Files
| Path | Change | +/− |
|---|---|---|
| src/test/regress/expected/test_setup.out | modified | +7 −0 |
| src/test/regress/sql/test_setup.sql | modified | +8 −0 |
Discussion
- create_index test fails when synchronous_commit = off @ master 7 messages · 2022-02-24 → 2022-03-12