[Pgpool-general] Slow performance with select queries ( even with a single node )

[Fernando Morgenstern]

Hello,

Sorry for this post. Just found out that pgpool was running in debug  
mode. Taking debug out, i get a similar result.

Regards,
---

Fernando Marcelo
www.consultorpc.com
fernando at consultorpc.com
Tel: +34 902 998971
Fax: +34 91 7903701

## legal disclaimer

The information contained in this email is confidential. It is  
intended only
for the stated addressee(s) and access to it by any other person is
unauthorized. If you are not an addressee, you must not disclose, copy,
circulate or in any other way use or rely on the information contained  
in
this email. Such unauthorized use may be unlawful. If you have  
received this
email in error, please inform us immediately by emailing admin at consultorpc.com
and delete it and all copies from your system.

## end mail

Em 23/12/2009, às 18:36, Fernando Morgenstern escreveu:

> Hi,
>
> I was doing some tests with pgbench and found that TPS with pgpool  
> is extremely low. I am running a script with only select queries  
> that are the most common on my web application.
>
> Here it is my pgbench results:
>
> [root at im-pp1 ~]# pgbench -C -c 100 -h 192.168.100.51 -p 4000  -f  
> queriesAdapted-v2.sql -d demo -U postgres 2>&1 | grep tps
> tps = 43.705665 (including connections establishing)
> tps = 74.231368 (excluding connections establishing)
> [root at im-pp1 ~]# pgbench -C -c 100 -h 192.168.100.51   -f  
> queriesAdapted-v2.sql -d demo -U postgres 2>&1 | grep tps
> tps = 4.681445 (including connections establishing)
> tps = 6.164050 (excluding connections establishing)
>
> Postgres runs on port 4000 and pgpool on 5432. So the last one is  
> pgpool.
>
> For this test, i have detached ALL nodes, only leaving the current  
> one.
>
> Is there any particular reason why pgpool is having such a bad result?
>
> I believe that it is normal to have performance decrease when you  
> have multiple nodes, but in this case, there is only one node.
>
> Best Regards,
> ---
>
> Fernando Marcelo
> www.consultorpc.com
> fernando at consultorpc.com
> Tel: +34 902 998971
> Fax: +34 91 7903701
>
> ## legal disclaimer
>
> The information contained in this email is confidential. It is  
> intended only
> for the stated addressee(s) and access to it by any other person is
> unauthorized. If you are not an addressee, you must not disclose,  
> copy,
> circulate or in any other way use or rely on the information  
> contained in
> this email. Such unauthorized use may be unlawful. If you have  
> received this
> email in error, please inform us immediately by emailing admin at consultorpc.com
> and delete it and all copies from your system.
>
> ## end mail
>
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20091223/a04a71b2/attachment.html>