From: | Sbob <sbob(at)quadratum-braccas(dot)com> |
---|---|
To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | pgpool not load balancing via foreign table |
Date: | 2024-06-22 04:30:10 |
Message-ID: | 9e3a7634-b719-44ea-8075-e839061b9648@quadratum-braccas.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
All;
I created a db node with 2 standby's
then I setup pgpool and set it up with hosts talking to the 3 backend
nodes above
then I created a stand alone db cluster, and setup a foreign server
pointing to the pgpool node, then I used the IMPORT FOREIGN SCHEMA to
import the tables via the pgpool node.
all this worked great
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
Anyone have any ideas of how to get these stats?
Thanks in advance
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2024-06-22 05:05:04 | Re: pgpool not load balancing via foreign table |
Previous Message | Naveed Iftikhar | 2024-06-21 16:26:45 | Re: Monitoring Script for Postgres |