[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