MIME-Version: 1.0
From: Adam Blomeke <adam.blomeke@gmail.com>
Date: Fri, 17 Apr 2026 15:11:08 -0400
Message-ID: 
 <CAG9AmsgiQgDhQWZ6viVEWwtX4h_ukjvgN=DhiWKKCAvHMyC=yQ@mail.gmail.com>
Subject: Routing of FDW Queries to Secondary databases
To: pgpool-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000ccf845064facb645"
Archived-At: 
 <https://www.postgresql.org/message-id/CAG9AmsgiQgDhQWZ6viVEWwtX4h_ukjvgN%3DDhiWKKCAvHMyC%3DyQ%40mail.gmail.com>
Precedence: bulk

--000000000000ccf845064facb645
Content-Type: text/plain; charset="UTF-8"

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

--000000000000ccf845064facb645
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Hi,</div><div><br></div><div>I understand that FDW qu=
eries don&#39;t get routed to the secondary databases since they occur with=
in FETCH blocks. Is there any planned work to change this.=C2=A0I have one =
database I&#39;m about to work on clusterizing, but this limitation makes p=
gpool impractical as the read side is only accessed via FDWs in all but a v=
ery small set of circumstances.=C2=A0</div><div><br></div><div>Again, I rea=
lize the existing limitation; I&#39;m just curious if there&#39;s any work =
on the horizon to add that capability. If not, I will likely need to explor=
e other alternatives for one of the clusters I&#39;m working on.</div><div>=
<br></div><div><div dir=3D"ltr" class=3D"gmail_signature" data-smartmail=3D=
"gmail_signature"><div dir=3D"ltr"><div><div dir=3D"ltr"><div>Cheers,</div>=
Adam<br></div></div></div></div></div></div>

--000000000000ccf845064facb645--