diff options
| author | Christian Grothoff <christian@grothoff.org> | 2024-03-06 22:20:57 +0100 |
|---|---|---|
| committer | Christian Grothoff <christian@grothoff.org> | 2024-03-06 22:20:57 +0100 |
| commit | b8c5d140050d3fea860a7b7c13612d14a7aebe2d (patch) | |
| tree | 1176a26b82462187ecf18c34c867b12779debc2c | |
| parent | 9173d2747f00921dccf1678b877f7f250fca9cd3 (diff) | |
| download | exchange-b8c5d140050d3fea860a7b7c13612d14a7aebe2d.tar.gz exchange-b8c5d140050d3fea860a7b7c13612d14a7aebe2d.tar.bz2 exchange-b8c5d140050d3fea860a7b7c13612d14a7aebe2d.zip | |
disable merge join to 'fix' #8452
| -rw-r--r-- | src/exchangedb/pg_lookup_transfer_by_deposit.c | 1 | ||||
| -rw-r--r-- | src/exchangedb/plugin_exchangedb_postgres.c | 5 |
2 files changed, 5 insertions, 1 deletions
diff --git a/src/exchangedb/pg_lookup_transfer_by_deposit.c b/src/exchangedb/pg_lookup_transfer_by_deposit.c index cb600f080..ba4efcefd 100644 --- a/src/exchangedb/pg_lookup_transfer_by_deposit.c +++ b/src/exchangedb/pg_lookup_transfer_by_deposit.c @@ -141,6 +141,7 @@ TEH_PG_lookup_transfer_by_deposit ( &wire_salt), GNUNET_PQ_result_spec_string ("payto_uri", &payto_uri), + /* See Postgresql bug #18380 */ #define BUG 1 #if BUG GNUNET_PQ_result_spec_allow_null ( diff --git a/src/exchangedb/plugin_exchangedb_postgres.c b/src/exchangedb/plugin_exchangedb_postgres.c index 0de656987..2c51a5bf1 100644 --- a/src/exchangedb/plugin_exchangedb_postgres.c +++ b/src/exchangedb/plugin_exchangedb_postgres.c @@ -272,6 +272,8 @@ TEH_PG_internal_setup (struct PostgresClosure *pg) GNUNET_PQ_make_try_execute ("SET enable_sort=OFF;"), GNUNET_PQ_make_try_execute ("SET enable_seqscan=OFF;"), GNUNET_PQ_make_try_execute ("SET search_path TO exchange;"), + /* Mergejoin causes issues, see Postgres #18380 */ + GNUNET_PQ_make_try_execute ("SET enable_mergejoin=OFF;"), GNUNET_PQ_EXECUTE_STATEMENT_END }; #else @@ -280,7 +282,8 @@ TEH_PG_internal_setup (struct PostgresClosure *pg) "SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL SERIALIZABLE;"), GNUNET_PQ_make_try_execute ("SET enable_sort=OFF;"), GNUNET_PQ_make_try_execute ("SET enable_seqscan=OFF;"), - GNUNET_PQ_make_try_execute ("SET autocommit=OFF;"), + /* Mergejoin causes issues, see Postgres #18380 */ + GNUNET_PQ_make_try_execute ("SET enable_mergejoin=OFF;"), GNUNET_PQ_make_try_execute ("SET search_path TO exchange;"), GNUNET_PQ_EXECUTE_STATEMENT_END }; |