[pgpool-hackers: 460] Re: Multi statement query
Bruce Momjian
bruce at momjian.us
Thu Feb 13 10:26:15 JST 2014
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. +
More information about the pgpool-hackers
mailing list