FDW/Foriegn Table pointing to pgpool never gets load balanced
| От | Sbob |
|---|---|
| Тема | FDW/Foriegn Table pointing to pgpool never gets load balanced |
| Дата | |
| Msg-id | b79819be-14bc-4e3b-a4e0-4ca25aad4b79@quadratum-braccas.com обсуждение исходный текст |
| Список | pgsql-admin |
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
В списке pgsql-admin по дате отправления: