[Pgpool-general] slow pgpool-II-3.1

2011-10-06 Thread Armin Nesiren
Hi everyone, I'm experiencing performance issues with pgpool-3.1 Problem is that when I connect through pgpool to database, database works slower than when I connect directly to master. In this test case, I have disabled node2, just to check performance directly and through pgpool. What can be a

Re: [Pgpool-general] slow pgpool-II-3.1

2011-10-06 Thread Guillaume Lelarge
On Thu, 2011-10-06 at 14:36 +0200, Armin Nesiren wrote: Hi everyone, I'm experiencing performance issues with pgpool-3.1 Problem is that when I connect through pgpool to database, database works slower than when I connect directly to master. In this test case, I have disabled node2, just

Re: [Pgpool-general] slow pgpool-II-3.1

2011-10-06 Thread Guillaume Lelarge
On Thu, 2011-10-06 at 14:56 +0200, Armin Nesiren wrote: On Thu, Oct 6, 2011 at 2:48 PM, Guillaume Lelarge guilla...@lelarge.infowrote: On Thu, 2011-10-06 at 14:36 +0200, Armin Nesiren wrote: Hi everyone, I'm experiencing performance issues with pgpool-3.1 Problem is that when I

Re: [Pgpool-general] slow pgpool-II-3.1

2011-10-06 Thread Olivier NOEL
2011/10/6 Guillaume Lelarge guilla...@lelarge.info: On Thu, 2011-10-06 at 14:56 +0200, Armin Nesiren wrote: On Thu, Oct 6, 2011 at 2:48 PM, Guillaume Lelarge guilla...@lelarge.infowrote: On Thu, 2011-10-06 at 14:36 +0200, Armin Nesiren wrote: Hi everyone, I'm experiencing

Re: [Pgpool-general] slow pgpool-II-3.1

2011-10-06 Thread Olivier NOEL
2011/10/6 Guillaume Lelarge guilla...@lelarge.info: [...] And it's not. Ok, there is some overhead, but it's veeery slow. How did you check that? You may be right in a specific setting, but I have no issues getting better performance with pgpool. We tested our java webapp with pgpool and

Re: [Pgpool-general] slow pgpool-II-3.1

2011-10-06 Thread Guillaume Lelarge
On Thu, 2011-10-06 at 17:27 +0200, Olivier NOEL wrote: 2011/10/6 Guillaume Lelarge guilla...@lelarge.info: [...] And it's not. Ok, there is some overhead, but it's veeery slow. How did you check that? You may be right in a specific setting, but I have no issues getting better

Re: [Pgpool-general] slow pgpool-II-3.1

2011-10-06 Thread Olivier NOEL
2011/10/6 Guillaume Lelarge guilla...@lelarge.info: On Thu, 2011-10-06 at 17:27 +0200, Olivier NOEL wrote: 2011/10/6 Guillaume Lelarge guilla...@lelarge.info: [...] And it's not. Ok, there is some overhead, but it's veeery slow. How did you check that? You may be right in a