pgsql: Set synchronous_commit=on in test_setup.sql. - Mailing list pgsql-committers

From Andres Freund
Subject pgsql: Set synchronous_commit=on in test_setup.sql.
Date
Msg-id E1nTA3P-000TMU-Le@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
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

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/02fea8fdda6531f34305b445f92f5b62241329b3

Modified Files
--------------
src/test/regress/expected/test_setup.out | 7 +++++++
src/test/regress/sql/test_setup.sql      | 8 ++++++++
2 files changed, 15 insertions(+)


pgsql-committers by date:

Previous
From: Peter Geoghegan
Date:
Subject: pgsql: vacuumlazy.c: Standardize rel_pages terminology.
Next
From: Andres Freund
Date:
Subject: pgsql: Force track_io_timing off in explain.sql to avoid failures when