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

[Tatsuo Ishii]

>> 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