[PERFORM] Suggestions for benchmarking 7.4RC2 against 7.3

2003-11-11 Thread Rajesh Kumar Mallah
Hi, I plan to put 7.4-RC2 in our production servers in next few hours. Since the hardware config the performance related GUCs parameter are going to remain the same i am interested in seeing the performance improvements in 7.4 as compared 7.3 . For this i plan to use the OSDB 0.14 and

Re: [PERFORM] Suggestions for benchmarking 7.4RC2 against 7.3

2003-11-11 Thread Rajesh Kumar Mallah
the error mentioned in first email has been overcome by running osdb on the same machine hosting the DB server. regds mallah. Rajesh Kumar Mallah wrote: Hi, I plan to put 7.4-RC2 in our production servers in next few hours. Since the hardware config the performance related GUCs parameter

Re: [PERFORM] Suggestions for benchmarking 7.4RC2 against 7.3

2003-11-11 Thread Christopher Browne
After a long battle with technology,[EMAIL PROTECTED] (Rajesh Kumar Mallah), an earthling, wrote: the error mentioned in first email has been overcome by running osdb on the same machine hosting the DB server. Yes, it seems unrealistic to try to run the client on a separate host from the

Re: [PERFORM] Suggestions for benchmarking 7.4RC2 against 7.3

2003-11-11 Thread Josh Berkus
Rajesh, Chris, I got the osdb benchmark running last week, and had to separate client from server. I had to jump through a fair number of hoops including copying data files over to the server. The benchmark software needs a bit more work... What about the OSDL's TPC-derivative benchmarks?

Re: [PERFORM] Suggestions for benchmarking 7.4RC2 against 7.3

2003-11-11 Thread Rajesh Kumar Mallah
Josh Berkus wrote: Rajesh, Chris, I got the osdb benchmark running last week, and had to separate client from server. I had to jump through a fair number of hoops including copying data files over to the server. The benchmark software needs a bit more work... What

Re: [PERFORM] Suggestions for benchmarking 7.4RC2 against 7.3

2003-11-11 Thread Rajesh Kumar Mallah
RC2 is running in production without any apparent problems till now. Well its difficult to say at the moment how much speed gain is there unless the heavy duty batch SQL scripts are run by cron. Count(*) and group by on large tables are significantly (5x) faster and better error reporting