[Pgpool-general] pgpool-II 2.1 beta1 release

[Yoshiyuki Asaba]

Hi,

From: Yoshiyuki Asaba <y-asaba at sraoss.co.jp>
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
y-asaba at sraoss.co.jp
-------------- next part --------------
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 ----