Routing of FDW Queries to Secondary databases

From: Adam Blomeke <adam(dot)blomeke(at)gmail(dot)com>
To: pgpool-general(at)lists(dot)postgresql(dot)org
Subject: Routing of FDW Queries to Secondary databases
Date: 2026-04-17 19:11:08
Message-ID: CAG9AmsgiQgDhQWZ6viVEWwtX4h_ukjvgN=DhiWKKCAvHMyC=yQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgpool-general

Hi,

I understand that FDW queries don't get routed to the secondary databases
since they occur within FETCH blocks. Is there any planned work to change
this. I have one database I'm about to work on clusterizing, but this
limitation makes pgpool impractical as the read side is only accessed via
FDWs in all but a very small set of circumstances.

Again, I realize the existing limitation; I'm just curious if there's any
work on the horizon to add that capability. If not, I will likely need to
explore other alternatives for one of the clusters I'm working on.

Cheers,
Adam

Responses

Browse pgpool-general by date

  From Date Subject
Next Message Tatsuo Ishii 2026-04-22 05:36:06 Re: Routing of FDW Queries to Secondary databases
Previous Message Koshino Taiki 2026-04-09 05:11:24 Re: pgpool-II 4.4.16: Version mismatch between configure.ac and generated configure script