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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])