[Pgpool-general] Multi-statement queries

2010-03-05 Thread Matthias Tief
Hallo, we are planning to use pgpool-II as replication solution for our PostgeSQL application. Currently we evaluate, whether the restriction of pgpool-II affect our application. In the documentation you say: "pgpool-II cannot process multi-statement query." What do you exactly mean with "multi-s

Re: [Pgpool-general] Multi-statement queries

2010-03-05 Thread Guillaume Lelarge
Le 05/03/2010 09:45, Matthias Tief a écrit : > Hallo, > > we are planning to use pgpool-II as replication solution for our > PostgeSQL application. Currently we evaluate, whether the restriction of > pgpool-II affect our application. In the documentation you say: > "pgpool-II cannot process multi-

Re: [Pgpool-general] Multi-statement queries

2010-03-09 Thread Matthias Tief
Thank you for your rapid answer. But for me it is still not clear. What you describe seems to be a collection of statements transmitted as a single transaction. But this is done very well by pgpool-II in my tests. I am wrong with that? So than my question is: What is the difference between "mult

Re: [Pgpool-general] Multi-statement queries

2010-03-09 Thread Daniel . Crespo
-general@pgfoundry.org > Subject: Re: [Pgpool-general] Multi-statement queries > > Thank you for your rapid answer. > > But for me it is still not clear. What you describe seems to be a > collection of statements transmitted as a single transaction. But this > is done very we

Re: [Pgpool-general] Multi-statement queries

2010-03-09 Thread Glyn Astill
Yeah I'm with Daniel on this one, Tatsuo? --- On Tue, 9/3/10, daniel.cre...@l-3com.com wrote: > From: daniel.cre...@l-3com.com > Subject: Re: [Pgpool-general] Multi-statement queries > To: "Matthias Tief" , pgpool-general@pgfoundry.org > Date: Tuesday, 9 March, 201

Re: [Pgpool-general] Multi-statement queries

2010-03-10 Thread Tatsuo Ishii
> boun...@pgfoundry.org] On Behalf Of Matthias Tief > > Sent: Tuesday, March 09, 2010 4:11 AM > > To: pgpool-general@pgfoundry.org > > Subject: Re: [Pgpool-general] Multi-statement queries > > > > Thank you for your rapid answer. > > > > But for me it is

Re: [Pgpool-general] Multi-statement queries

2010-03-10 Thread Cesar Martin
directly to > > PostgreSQL. > > > > Daniel > > > > > -Original Message- > > > From: pgpool-general-boun...@pgfoundry.org > > [mailto:pgpool-general- > > > boun...@pgfoundry.org] > > On Behalf Of Matthias Tief > > > Sent:

Re: [Pgpool-general] Multi-statement queries

2010-03-10 Thread Tatsuo Ishii
p://www.sraoss.co.jp > Regards. > > > 2010/3/9 Glyn Astill > > > Yeah I'm with Daniel on this one, Tatsuo? > > > > --- On Tue, 9/3/10, daniel.cre...@l-3com.com > > wrote: > > > > > From: daniel.cre...@l-3com.com > > &g

Re: [Pgpool-general] Multi-statement queries

2010-03-10 Thread Glyn Astill
Ah, I see. --- On Wed, 10/3/10, Cesar Martin wrote: > From: Cesar Martin > Subject: Re: [Pgpool-general] Multi-statement queries > To: "Glyn Astill" > Cc: "Matthias Tief" , pgpool-general@pgfoundry.org, > daniel.cre...@l-3com.com > Date: Wednesday, 10 Ma

Re: [Pgpool-general] Multi-statement queries

2010-03-10 Thread Matthias Tief
wrote: From: daniel.cre...@l-3com.com Subject: Re: [Pgpool-general] Multi-statement queries To: "Matthias Tief" , pgpool-general@pgfoundry.org Date: Tuesday, 9 March, 2010, 14:50 My experience is also that multi-statement queries ("statement1; statement2; ...; statementN;") w

Re: [Pgpool-general] Multi-statement queries

2010-03-10 Thread Daniel . Crespo
art...@gmail.com; glynast...@yahoo.co.uk; Crespo, Daniel @ SDS; > pgpool-general@pgfoundry.org > Subject: Re: [Pgpool-general] Multi-statement queries > > Hi, > > As I understand one can avoid this problem by setting replicate_select > = > true, right? But than one will have almost no

Re: [Pgpool-general] Multi-statement queries

2010-03-11 Thread Matthias Tief
pgpool-general@pgfoundry.org Subject: Re: [Pgpool-general] Multi-statement queries Hi, As I understand one can avoid this problem by setting replicate_select = true, right? But than one will have almost no load balancing anymore. Matthias Tatsuo Ishii schrieb: Hello there, My experience is that, the pro