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 > [email protected] > _______________________________________________ > Pgpool-general mailing list > [email protected] > http://pgfoundry.org/mailman/listinfo/pgpool-general _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
