[pgpool-general: 7038] Re: PREPARE STATMENTS
Bo Peng
pengbo at sraoss.co.jp
Tue May 26 16:43:47 JST 2020
hello,
On Fri, 22 May 2020 17:58:00 +0200
Franco Ricci <franco.ricc at gmail.com> wrote:
> I’s possible specify which server should execute a "prepared statement"?
> I noticed in pgpool 4.1 that ordinary query are routed on master or slave server according query action (SELECT, UPDATE etc.).
> If I create a PREPARE STATEMENT this query is routed always on master server and never executed on slave even if statements is only a SELECT query!
>
> There is a way to programmatic set which is the server that has to server a prepared statement?
No.
Pgpool doesn't load balance "prepared statement".
"Prepared statement" should be sent to primary only.
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
--
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan
More information about the pgpool-general
mailing list