Postgres Pro
Downloads
Home   >   mailing lists

Re: FUNC_MAX_ARGS benchmarks - Mailing list pgsql-hackers

From Joe Conway
Subject Re: FUNC_MAX_ARGS benchmarks
Date
Msg-id 3D4DB61D.1010703@joeconway.com
Whole thread Raw
In response to Re: FUNC_MAX_ARGS benchmarks  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: [COMMITTERS] pgsql-server/src include/utils/timestamp.h bac ...
Next
From: Joe Conway
Date:
Subject: Re: Planned simplification of catalog index updates