[pgpool-hackers: 461] Re: Multi statement query

Tatsuo Ishii ishii at postgresql.org
Thu Feb 13 10:32:18 JST 2014

>> However there's a room to enhance this. Here's the revised algorithm:
>> 1) If the query includes SET command which must be sent to all the DB
>>    nodes:
> When you say all DB nodes, do you mean the master and the slave that is
> being used for that session, or all slaves.  I am unclear how sending it
> to all slaves would help.  Wouldn't that interfere with other users.

Right. However, currently pgpool-II sends to primary and not only one
of the standbys but rest standbys. If you have only one standby, that
does not harm though.

Best regards,
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

More information about the pgpool-hackers mailing list