[taler-exchange] branch master updated: disable merge join to 'fix' #8452

[gnunet]

This is an automated email from the git hooks/post-receive script.

grothoff pushed a commit to branch master
in repository exchange.

The following commit(s) were added to refs/heads/master by this push:
     new b8c5d140 disable merge join to 'fix' #8452
b8c5d140 is described below

commit b8c5d140050d3fea860a7b7c13612d14a7aebe2d
Author: Christian Grothoff <christian@grothoff.org>
AuthorDate: Wed Mar 6 22:20:57 2024 +0100

    disable merge join to 'fix' #8452
---
 src/exchangedb/pg_lookup_transfer_by_deposit.c | 1 +
 src/exchangedb/plugin_exchangedb_postgres.c    | 5 ++++-
 2 files changed, 5 insertions(+), 1 deletion(-)

diff --git a/src/exchangedb/pg_lookup_transfer_by_deposit.c 
b/src/exchangedb/pg_lookup_transfer_by_deposit.c
index cb600f08..ba4efcef 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 0de65698..2c51a5bf 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
     };

-- 
To stop receiving notification emails like this one, please contact
gnunet@gnunet.org.