Re: [HACKERS] Prepare enabled pgbench

2003-01-19 Thread Justin Clift
Hi Curtis, Have you had time to get this done? :-) Regards and best wishes, Justin Clift Curtis Faith wrote: Tatsuo Ishii <[EMAIL PROTECTED]> writes: Thanks. I can commit it for 7.4. BTW, it would be nice if we could have a switch to turn on/off PREPARE/EXECUTE in pgbench so that we could

Re: [HACKERS] Prepare enabled pgbench

2002-11-12 Thread Tom Lane
Tatsuo Ishii <[EMAIL PROTECTED]> writes: > Thanks. I can commit it for 7.4. BTW, it would be nice if we could > have a switch to turn on/off PREPARE/EXECUTE in pgbench so that we > could see how PRPARE/EXECUTE could improve the performance... That is a *must*. Otherwise, you've simply made an arb

Re: [HACKERS] Prepare enabled pgbench

2002-11-12 Thread Tatsuo Ishii
> > My concern is PREPARE/EXECUTE may NOT always improve the > > performance. I guess we have very few data to judge PREPARE/EXECUTE is > > good or not. Moreover PREPARE/EXECUTE might be improved in the > > future. If that happens, keeping that switch would help examining the > > effect, no? > > I

Re: [HACKERS] Prepare enabled pgbench

2002-11-12 Thread Bruce Momjian
Tatsuo Ishii wrote: > > > But one of the purposes of pgbench is examining performance on > > > different environments, doesn't it? I'm afraid hard coded > > > PREPARE/EXECUTE makes it harder. > > > > I was just thinking that pgbench is for measuring code changes, not for > > testing changes _in_ p

Re: [HACKERS] Prepare enabled pgbench

2002-11-12 Thread Tatsuo Ishii
> > But one of the purposes of pgbench is examining performance on > > different environments, doesn't it? I'm afraid hard coded > > PREPARE/EXECUTE makes it harder. > > I was just thinking that pgbench is for measuring code changes, not for > testing changes _in_ pgbench. Once we know the perfor

Re: [HACKERS] Prepare enabled pgbench

2002-11-12 Thread Bruce Momjian
Tatsuo Ishii wrote: > > > Thanks. I can commit it for 7.4. BTW, it would be nice if we could > > > have a switch to turn on/off PREPARE/EXECUTE in pgbench so that we > > > could see how PRPARE/EXECUTE could improve the performance... > > > > We could probably just run before-after patch tests to s

Re: [HACKERS] Prepare enabled pgbench

2002-11-12 Thread Tatsuo Ishii
> > Thanks. I can commit it for 7.4. BTW, it would be nice if we could > > have a switch to turn on/off PREPARE/EXECUTE in pgbench so that we > > could see how PRPARE/EXECUTE could improve the performance... > > We could probably just run before-after patch tests to see the > performance change.

Re: [HACKERS] Prepare enabled pgbench

2002-11-12 Thread Bruce Momjian
Tatsuo Ishii wrote: > > Tatsuo, are you or anyone else working on adding PREPARE, EXECUTE support to > > pgbench? > > As far as I know, no one is working on that. > > > If not, I can do it myself and if you are interested, I'll send you the > > patch. > > Thanks. I can commit it for 7.4. BTW, it

Re: [HACKERS] Prepare enabled pgbench

2002-11-12 Thread Tatsuo Ishii
> Tatsuo, are you or anyone else working on adding PREPARE, EXECUTE support to > pgbench? As far as I know, no one is working on that. > If not, I can do it myself and if you are interested, I'll send you the > patch. Thanks. I can commit it for 7.4. BTW, it would be nice if we could have a swit

[HACKERS] Prepare enabled pgbench

2002-11-12 Thread Curtis Faith
Tatsuo, are you or anyone else working on adding PREPARE, EXECUTE support to pgbench? If not, I can do it myself and if you are interested, I'll send you the patch. - Curtis ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http