Hi,
From: Yoshiyuki Asaba <[EMAIL PROTECTED]>
Subject: Re: [Pgpool-general] pgpool-II 2.1 beta1 release
Date: Wed, 19 Mar 2008 17:49:31 +0900 (JST)
> > > [...]
> > > I do a performance test on pgpool-II 2.1 beta1 and pgpool-II 1.x.
> > >
> > > * pgpoo.conf
> >
> > Attached mine below [0]
> [snip]
> > All servers are Dell 1955 blade, 8 GiB RAM, 8* 2.33GHz XEON, Raid 1 on 15k
> > sas hds.
>
> Thank you for the report. I'll check in my environment.
Could you apply the attached patch to pgpool-II 2.1 beta1?
* pgpool-II 2.1 beta1 without the patch
number of clients: 30
number of transactions per client: 50000
number of transactions actually processed: 1500000/1500000
tps = 28901.220676 (including connections establishing)
tps = 29520.719314 (excluding connections establishing)
* pgpool-II 2.1 beta1 with the patch
number of clients: 30
number of transactions per client: 50000
number of transactions actually processed: 1500000/1500000
tps = 32333.073771 (including connections establishing)
tps = 32992.818849 (excluding connections establishing)
Regards,
--
Yoshiyuki Asaba
[EMAIL PROTECTED]
Index: pool_process_query.c
===================================================================
RCS file: /cvsroot/pgpool/pgpool-II/pool_process_query.c,v
retrieving revision 1.104
diff -c -r1.104 pool_process_query.c
*** pool_process_query.c 13 Mar 2008 13:11:13 -0000 1.104
--- pool_process_query.c 26 Mar 2008 07:40:46 -0000
***************
*** 1966,1973 ****
if (send_ready)
{
- pool_flush(frontend);
-
pool_write(frontend, "Z", 1);
if (MAJOR(backend) == PROTO_MAJOR_V3)
--- 1966,1971 ----
***************
*** 3895,3902 ****
ret = SimpleForwardToFrontend(kind1, frontend, backend);
if (ret != POOL_CONTINUE)
return ret;
- if (pool_flush(frontend))
- return POOL_END;
}
if (ret != POOL_CONTINUE)
--- 3893,3898 ----
_______________________________________________
Pgpool-general mailing list
[email protected]
http://pgfoundry.org/mailman/listinfo/pgpool-general
