public inbox for [email protected]  

help / color / mirror / Atom feed

From: Álvaro Herrera <[email protected]>
To: Mladen Marinović <[email protected]>
Cc: Efrain J. Berdecia <[email protected]>
Cc: SERHAD ERDEM <[email protected]>
Cc: Achilleas Mantzios <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Different execution plans in PG17 and pgBouncer...
Date: Mon, 5 May 2025 16:08:03 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAHjkqPQCmRwDMLSX2N_Gp+5WL+xJbtaoF2_aVCHxxQFPQApFxA@mail.gmail.com>

On 2025-May-05, Mladen Marinović wrote:

> Hi,
> 
> Mystery not solved...but identified. The pool is in transaction mode and
> some connections use set enable_mergejoin=off, but they do not set it back
> to on.

Maybe instead of "SET enable_mergejoin=off" these connections could be
changed to use SET LOCAL enable_mergejoin=off.  That way, the setting
reverts to its original value automatically at the end of the
transaction.  It seems more appropriate when using transaction mode
anyway.

-- 
Álvaro Herrera               48°01'N 7°57'E  —  https://www.EnterpriseDB.com/

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Different execution plans in PG17 and pgBouncer...
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox