Horton
Menu

Re: FUNC_MAX_ARGS benchmarks

Joe Conway <mail@joeconway.com>

View thread
From: Joe Conway <mail@joeconway.com>
To:
Cc: Bruce Momjian <pgman@candle.pha.pa.us>, Tom Lane <tgl@sss.pgh.pa.us>, Thomas Lockhart <lockhart@fourpalms.org>, Neil Conway <nconway@klamath.dyndns.org>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2002-08-04T23:17:49Z
Lists: pgsql-hackers 
Joe Conway wrote:
> These are all with FUNC_MAX_ARGS = 16.
> 
> #define NAMEDATALEN 32
> du -h --max-depth=1 /opt/data/pgsql/data/base/
> 2.7M    /opt/data/pgsql/data/base/1
> 2.7M    /opt/data/pgsql/data/base/16862
> 2.7M    /opt/data/pgsql/data/base/16863
> 2.7M    /opt/data/pgsql/data/base/16864
> 3.2M    /opt/data/pgsql/data/base/16865
> 2.7M    /opt/data/pgsql/data/base/16866
> 2.7M    /opt/data/pgsql/data/base/17117
> 19M     /opt/data/pgsql/data/base
> 

FWIW, this is FUNC_MAX_ARGS = 32 *and* NAMEDATALEN 128
du -h --max-depth=1 /opt/data/pgsql/data/base/
4.1M    /opt/data/pgsql/data/base/1
4.1M    /opt/data/pgsql/data/base/16863
4.1M    /opt/data/pgsql/data/base/16864
4.1M    /opt/data/pgsql/data/base/16865
4.8M    /opt/data/pgsql/data/base/16866
4.1M    /opt/data/pgsql/data/base/16867
26M     /opt/data/pgsql/data/base

Joe