[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

[Pgpool-general] How to configure pgpool for pool conexions..

2011-10-06 Thread Matias Israel Malpica Escobar
Hi everyone i´ve been trying to understand and configure pgpool for a pool of connections (not sure if that is the term), i already follow a manual and confiigure it like this: listen_addresses = '*' port = pcp_port = 9898 socket_dir = '/var/run/postgresql' pcp_socket_dir =

Re: [Pgpool-general] How to configure pgpool for pool conexions..

2011-10-06 Thread Guillaume Lelarge
On Thu, 2011-10-06 at 10:59 -0500, Matias Israel Malpica Escobar wrote: Hi everyone i´ve been trying to understand and configure pgpool for a pool of connections (not sure if that is the term), i already follow a manual and confiigure it like this: listen_addresses = '*' port =

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] How to configure pgpool for pool conexions..

2011-10-06 Thread Guillaume Lelarge
On Thu, 2011-10-06 at 11:13 -0500, Matias Israel Malpica Escobar wrote: Hi thanks for your answers, what i wanted to say about the connections and errors from pgpool was that, for what i understand postgres returns an error if the number of connections are higher than its maximum, and pgpool

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

Re: [Pgpool-general] How to configure pgpool for pool conexions..

2011-10-06 Thread Matias Israel Malpica Escobar
Another question for you guys... I have succesfully installed and configure pgpool, if i go to pgadmin and connect to port of my server i can see the databases and everything... but when i try to run the following i get this error: [root@etc]# psql -d test -U testuser -p psql: could

Re: [Pgpool-general] How to configure pgpool for pool conexions..

2011-10-06 Thread Jose Mendoza
What is opening the port pgpool or the database? Sometimes I found out that postgres opens the port and have to stop pgpool and postgres and restart postgrsql and pgpool again. Jose Autonomy Ops verificare tua hinc -Original Message- From: pgpool-general-boun...@pgfoundry.org

Re: [Pgpool-general] How to configure pgpool for pool conexions..

2011-10-06 Thread Jose Mendoza
If your database opens the port then pgpool finds it in use when it starts. Jose Autonomy Ops verificare tua hinc -Original Message- From: Matias Israel Malpica Escobar [mailto:matias.malp...@thyssenkrupp.com] Sent: Thursday, October 06, 2011 2:39 PM To: Jose Mendoza Cc:

Re: [Pgpool-general] How to configure pgpool for pool conexions..

2011-10-06 Thread Matias Israel Malpica Escobar
Thanks for the quick reply, mmm but i never configure the databse to open the port , would it help if i copy my pgpool.config file? De: Jose Mendoza [jose.mend...@autonomy.com] Enviado el: jueves, 06 de octubre de 2011 04:47 p.m. Para: Matias Israel

Re: [Pgpool-general] How to configure pgpool for pool conexions..

2011-10-06 Thread Alan Hodgson
On October 6, 2011 02:44:34 PM Matias Israel Malpica Escobar wrote: Another question for you guys... I have succesfully installed and configure pgpool, if i go to pgadmin and connect to port of my server i can see the databases and everything... but when i try to run the following i get

Re: [Pgpool-general] How to configure pgpool for pool conexions..

2011-10-06 Thread Daniel . Crespo
-Original Message- From: pgpool-general-boun...@pgfoundry.org [mailto:pgpool-general- boun...@pgfoundry.org] On Behalf Of Alan Hodgson Sent: Thursday, October 06, 2011 5:52 PM To: pgpool-general@pgfoundry.org Subject: Re: [Pgpool-general] How to configure pgpool for pool conexions..