Re: pgpool not load balancing via foreign table

On Friday, June 21, 2024, David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
wrote:

> On Friday, June 21, 2024, Sbob <sbob(at)quadratum-braccas(dot)com> wrote:
>>
>>
>> however no matter how many selects I run via the foreign tables a "show
>> pool_nodes" on the pgpool server shows a select_cnt of 0 for all 3 nodes.
>>
>> If I connect to the pgpool server/cluster and run a number of select
>> statements then a "show pool_nodes" shows increasing values for all 3
>> backend nodes for select_cnt
>>
>>
>> It appears that a foreign table / FDW connection to a pgpool node does
>> not trigger the collection of any load balancing stats
>>
>>
> Skimming over the project and the extension (for the first time ever…) it
> seems pgpool only does stats in response to Execute messages while FDW is
> using the simple query protocol. That pgpool doesn’t do stats for Query as
> well seems like an oversight.
>

Nevermind…or at least while possible further reading of the pgpool code
doesn’t support it - the simple query case is present.

David J.