Re: INDEX_MAX_KEYS - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: INDEX_MAX_KEYS
Date
Msg-id 200203112211.g2BMBOs20787@candle.pha.pa.us
Whole thread Raw
In response to Re: INDEX_MAX_KEYS  (Jan Wieck <janwieck@yahoo.com>)
List pgsql-hackers
Jan Wieck wrote:
> > > > 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?

I don't think so.  I don't remember if there is a NULL bitmap that is
fixed length for indexes.  I don't think so.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Jan Wieck
Date:
Subject: Re: INDEX_MAX_KEYS
Next
From: Ian Barwick
Date:
Subject: Re: psql and output from \?