Horton
Menu

Re: FUNC_MAX_ARGS benchmarks

Joe Conway <mail@joeconway.com>

View thread
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-03T21:24:45Z
Lists: pgsql-hackers 
Tom Lane wrote:
> Did you happen to make any notes about the disk space occupied by the
> database?  One thing I was worried about was the bloat that'd occur
> in pg_proc, pg_index, and pg_proc_proname_args_nsp_index.  Aside from
> costing disk space, this would indirectly slow things down due to more
> I/O to read these tables --- an effect that probably your test couldn't
> measure, since it wasn't touching very many entries in any of those
> tables.

#define INDEX_MAX_KEYS        16
#define FUNC_MAX_ARGS        INDEX_MAX_KEYS
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
17M     /opt/data/pgsql/data/base

#define INDEX_MAX_KEYS        32
#define FUNC_MAX_ARGS        INDEX_MAX_KEYS
  du -h --max-depth=1 /opt/data/pgsql/data/base/
3.1M    /opt/data/pgsql/data/base/1
3.1M    /opt/data/pgsql/data/base/16862
3.1M    /opt/data/pgsql/data/base/16863
3.1M    /opt/data/pgsql/data/base/16864
3.6M    /opt/data/pgsql/data/base/16865
3.1M    /opt/data/pgsql/data/base/16866
19M     /opt/data/pgsql/data/base

#define INDEX_MAX_KEYS        64
#define FUNC_MAX_ARGS        INDEX_MAX_KEYS
du -h --max-depth=1 /opt/data/pgsql/data/base/
3.9M    /opt/data/pgsql/data/base/1
3.9M    /opt/data/pgsql/data/base/16862
3.9M    /opt/data/pgsql/data/base/16863
3.9M    /opt/data/pgsql/data/base/16864
4.4M    /opt/data/pgsql/data/base/16865
3.9M    /opt/data/pgsql/data/base/16866
24M     /opt/data/pgsql/data/base

#define INDEX_MAX_KEYS        128
#define FUNC_MAX_ARGS        INDEX_MAX_KEYS
du -h --max-depth=1 /opt/data/pgsql/data/base/
5.7M    /opt/data/pgsql/data/base/1
5.7M    /opt/data/pgsql/data/base/16862
5.7M    /opt/data/pgsql/data/base/16863
5.7M    /opt/data/pgsql/data/base/16864
6.3M    /opt/data/pgsql/data/base/16865
5.7M    /opt/data/pgsql/data/base/16866
35M     /opt/data/pgsql/data/base


Joe