Certainly you can change this. Edit the following file in your source tree: cbbrowne@wolfe:/brownes/wolfe/compiles/pgsql> vi src/include/pg_config_manual.h /* * Maximum number of columns in an index and maximum number of * arguments to a function. They must be the same value. * * The minimum value is 8 (index creation uses 8-argument functions). * There is no specific upper limit, although large values will waste * system-table space and processing time. * * Changing these requires an initdb. */ #define INDEX_MAX_KEYS 32 #define FUNC_MAX_ARGS INDEX_MAX_KEYS You will have to recompile PostgreSQL and create a fresh database instance using initdb with the new maxima for these configuration values. Fortunately, the ability to recompile as needed is kind of the whole point of this "open source" stuff... -- "cbbrowne","@","gmail.com" http://linuxdatabases.info/~cbbrowne/spreadsheets.html They are called computers simply because computation is the only significant job that has so far been given to them. -- Louis Ridenour ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
