[pgpool-general: 7041] Re: PREPARE STATMENTS

[Franco Ricci]

Prepared statement are wide used to avoid SQL injection and to speed up DB response in case of SELECT that are always the same.
Why is not possible balance  prepared statement?
It could bu useful if I can use something like “black_query_pattern_list” but in white flavour…

Franco

> On 26 May 2020, at 09:43, Bo Peng <pengbo at sraoss.co.jp> wrote:
> 
> 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