[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