From: | Andres Freund <andres(at)anarazel(dot)de> |
---|---|
To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
Subject: | pgsql: Set synchronous_commit=on in test_setup.sql. |
Date: | 2022-03-12 22:17:40 |
Message-ID: | E1nTA3P-000TMU-Le@gemulon.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)timescale(dot)com>
Author: Andres Freund <andres(at)anarazel(dot)de>
Author: Aleksander Alekseev <aleksander(at)timescale(dot)com>
Discussion: https://www.postgresql.org/message-id/flat/CAJ7c6TPJNof1Q+vJsy3QebgbPgXdu2ErPvYkBdhD6_Ckv5EZRg(at)mail(dot)gmail(dot)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(+)
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Freund | 2022-03-12 22:24:19 | pgsql: Force track_io_timing off in explain.sql to avoid failures when |
Previous Message | Peter Geoghegan | 2022-03-12 21:22:22 | pgsql: vacuumlazy.c: Standardize rel_pages terminology. |