pgpool not load balancing via foreign table

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

Responses

Browse pgsql-admin by date

  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