Re: FUNC_MAX_ARGS benchmarks

Joe Conway wrote:
> Bruce Momjian wrote:
> 
>> As long as we allocate the full length for the funcarg and name types,
>> we are going to have performance/space issues with increasing them,
>> especially since we are looking at doubling or quadrupling those values.
>>
>> You can say that the test below isn't a representative benchmark, but I
>> am sure it is typical of _some_ of our users, so it may still be a
>> significant test.  We don't get good benchmark numbers by accident.  It
>> is this type of analysis that keeps us sharp.
> 
> 
> I'm running the OSDB benchmark right now. So far the Single user test 
> results are done, and the overall results is like this:
> 
> NAMEDATALEN = 32, FUNC_MAX_ARGS = 32
> "Single User Test"      2205.89 seconds (0:36:45.89)
> 
> NAMEDATALEN = 128, FUNC_MAX_ARGS = 32
> "Single User Test"      2256.16 seconds (0:37:36.16)
> 
> So the difference in performance for this benchmark is not nearly so 
> large, more like 2%. The multi-user portion of the second test is 
> running right now, so I'll report final results in the morning. I might 
> also run this on the same machine against 7.2.1 to see where we would 
> stand in comparison to the last release. But that won't happen until 
> tomorrow some time.
> 

Here's the multi-user test summary. Very little difference. The details 
of the OSDB output are attached.

NAMEDATALEN = 32, FUNC_MAX_ARGS = 32
"Multi-User Test"       3403.84 seconds (0:56:43.84)

NAMEDATALEN = 128, FUNC_MAX_ARGS = 32
"Multi-User Test"       3412.18 seconds (0:56:52.18)

Joe