Re: INDEX_MAX_KEYS

From: Jan Wieck <janwieck(at)yahoo(dot)com>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Jan Wieck <janwieck(at)yahoo(dot)com>, Greg Copeland <greg(at)CopelandConsulting(dot)Net>, PostgresSQL Hackers Mailing List <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: INDEX_MAX_KEYS
Date: 2002-03-11 21:50:09
Message-ID: 200203112150.g2BLo9N28603@saturn.janwieck.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Bruce Momjian wrote:
> Jan Wieck wrote:
> > Bruce Momjian wrote:
> > > Greg Copeland wrote:
> > >
> > > Checking application/pgp-signature: FAILURE
> > > -- Start of PGP signed section.
> > > > I'm looking through the index code and just happened to notice that
> > > > INDEX_MAX_KEYS is currently set to 16. It there a reason for this value
> > > > to be at 16 or was it arbitrarily specified?
> > >
> > > Arbitrary, and there is discussion about increasing it.
> >
> > Wasn't it that this number had to be <= the maximum number of
> > function args?
>
> Yes, they are related. At least I think so. Anyway, the parameter that
> needs increasing is max function args. I got mixed up there.

Then again, if they are related, why not let the index max
keys be automatically set according to the function max arg
configuration? Is there any reason someone want's to limit
it smaller than the system could technically handle?

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2002-03-11 22:02:25 Re: numeric/decimal docs bug?
Previous Message Bruce Momjian 2002-03-11 21:34:54 Re: INDEX_MAX_KEYS