[Pgpool-general] Pgpool almost 20 times slower than normal postgres

[Fernando Morgenstern]

Hello,

I sent this email almost one month ago but didn't got any answer. I am still having this problem and can't find how to solve it.

Is there any additional info that i can provide?

Also, could you kindly share your experience with pgpool in this situation? ( eg.: this is normal to happen or i solved this problem by changing X )

Thanks!


Em 28/01/2010, às 08:59, Fernando Morgenstern escreveu:

> Hello,
> 
> We have been trying to identify what is causing our db cluster to be so slow but, as this is the first one that i am working, i am not sure if what i am getting is normal or not.
> 
> Basically we have a JSP script that connects to database and run a simple query on a table that currently have 23 rows:
> 
> select id,name from mytable;
> 
> This script returns the query time. So, when we run agains postgres directly, we get about 2 miliseconds.
> 
> But when we run against pgpool ( with 1-4 nodes, tried with all node count ), we get 40-42 miliseconds.
> 
> 
> What i would like to ask is it this is the normal behavior or could be something wrong with my setup?
> 
> Is there anything that i can do to speed up it?
> 
> Pgpool version is 2.3.1.
> 
> Best Regards,
> ---
> 
> Fernando Marcelo
> www.consultorpc.com
> fernando at consultorpc.com
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general