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/
