On Friday, June 21, 2024, David G. Johnston <
david.g.johnston@gmail.com> wrote:
On Friday, June 21, 2024, Sbob <sbob@quadratum-braccas.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.