Feedback-ID: i374947ac:Fastmail
Message-ID: <af7bb85a-c175-436e-a4ec-c86d9c9444df@quadratum-braccas.com>
Date: Wed, 22 Oct 2025 09:44:23 -0600
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
To: pgpool-general@lists.postgresql.org
Content-Language: en-US
From: Sbob <sbob@quadratum-braccas.com>
Subject: FDW/Foriegn Table pointing to pgpool never gets load balanced
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/af7bb85a-c175-436e-a4ec-c86d9c9444df%40quadratum-braccas.com>
Precedence: bulk

All;


I setup a Foreign Server pointing to a pgpool instance. Subsequently 
created Foreign Tables work as expected but they are never load 
balanced, it seems they always run on the first available node. My 
latest test used a pgpool config pointing to 2 standby's (no master) and 
set both backend nodes to DISALLOW failovers

I have load balancing configured and I have statement_level_load_balance 
= on

I set log_min_duration_statement to 0 on both backend nodes and ran 
several selects from the local Foreign table, I see this in the logfile 
from data node 0:


2025-10-21 08:52:53.876 MDT [58156] LOG:  duration: 0.032 ms statement: 
START TRANSACTION ISOLATION LEVEL REPEATABLE READ
2025-10-21 08:52:53.877 MDT [58156] LOG:  duration: 0.063 ms parse 
<unnamed>: DECLARE c1 CURSOR FOR
         SELECT id FROM public.abc WHERE ((id < 15))
2025-10-21 08:52:53.877 MDT [58156] LOG:  duration: 0.006 ms  bind 
<unnamed>: DECLARE c1 CURSOR FOR
         SELECT id FROM public.abc WHERE ((id < 15))
2025-10-21 08:52:53.877 MDT [58156] LOG:  duration: 0.043 ms execute 
<unnamed>: DECLARE c1 CURSOR FOR
         SELECT id FROM public.abc WHERE ((id < 15))
2025-10-21 08:52:53.878 MDT [58156] LOG:  duration: 0.043 ms statement: 
FETCH 100 FROM c1
2025-10-21 08:52:53.878 MDT [58156] LOG:  duration: 0.005 ms statement: 
CLOSE c1
2025-10-21 08:52:53.878 MDT [58156] LOG:  duration: 0.016 ms statement: 
COMMIT TRANSACTION


And I see this in the logfile from data node 1:


2025-10-21 08:52:27.675 MDT [58138] LOG:  duration: 0.026 ms statement: 
START TRANSACTION ISOLATION LEVEL REPEATABLE READ
2025-10-21 08:52:27.676 MDT [58138] LOG:  duration: 0.020 ms statement: 
COMMIT TRANSACTION


No matter how many selects I run from the Foreign Table I see the same 
entries in the data node postgres log files and it never load balances 
the queries from the Foreign Table


Anyone have any Ideas how to get this to load balance?


Thanks in advance