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

[Bruce Momjian]

On Thu, Feb 13, 2014 at 10:15:26AM +0900, Tatsuo Ishii wrote:
> >> Yes, exactly.
> > 
> > I must be missing something.  Why does a BEGIN/END block or SET need to
> > be sent to all nodes?  I understand INSERT only should be sent to the
> > master.
> 
> I don't want to devide the query string into each query part because
> it's very hard to process.

Yes, agreed.

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

-- 
  Bruce Momjian  <bruce at momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +