>I'd suggest looking at the mailing list archives What I must look for ???
"Stephan Szabo" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > On Thu, 28 Aug 2003, Ivar wrote: > > > I don't see why default is so small. > > Re-read Joe's response. There are performance and disk usage tradeoffs > for raising the limit. I'd suggest looking at the mailing list archives > for the discussion mentioned. > > > "Joe Conway" <[EMAIL PROTECTED]> wrote in message > > news:[EMAIL PROTECTED] > > > Ivar wrote: > > > > For my supprise I found that functions have 32 parameter limit. > > > > > > > > Where to find more info about this limitation or similar limitations ? > > > > > > > > I need at least 50, 100 would be ok. > > > > > > See INDEX_MAX_KEYS defined in src/include/pg_config.h.in > > > (pg_config_manual.h in postgres 7.4). Change to 64 or whatever and > > > recompile. But note that you'll need to dump, initdb, and reload your > > > data. Also note that there are performance and disk usage tradeoffs -- > > > search the mailing list archives from August 2002 for some test results > > > and discussion. > > > > > > Joe > > > > > > > > > ---------------------------(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 > > > > > > > > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 4: Don't 'kill -9' the postmaster > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) > ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
