Re: FUNC_MAX_ARGS benchmarks

Joe Conway <mail@joeconway.com>

From: Joe Conway <mail@joeconway.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Bruce Momjian <pgman@candle.pha.pa.us>, Thomas Lockhart <lockhart@fourpalms.org>, Neil Conway <nconway@klamath.dyndns.org>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2002-08-05T23:08:40Z
Lists: pgsql-hackers
Tom Lane wrote:
> Well, in fact it's not just a question of disk space.
> 
> The following numbers are stats for total elapsed time of "make
> installcheck" over ten trials:
> 
<snip>
> I'm not sure about the trend of increasing standard deviation --- that
> may reflect more disk I/O being done, and perhaps more checkpoints
> occurring during the test.  But in any case it's clear that there's a
> nontrivial runtime cost here.  Does a 10% slowdown bother you?

Hmmm -- didn't Neil do some kind of test that had different results, 
i.e. not much performance difference? I wonder if the large number of 
DDL commands in installcheck doesn't skew the results against longer 
NAMEDATALEN compared to other benchmarks?

# pwd
/opt/src/pgsql/src/test/regress/sql
# grep -i 'CREATE\|DROP' * | wc -l
    1114


Joe