Re: [HACKERS] Re: Postgres Features for 7.X

Bruce Momjian <pgman@candle.pha.pa.us> writes:
>> I've just remembered the other problem with PG that needs to be listed for
>> fixing.
>> 
>> This is the 7 field index limit

It's 8, not 7, afaik...

> I am working on this now.  7.0 will have a postgres.h parameter that can
> be changed.  Default is 8.

I looked at this a while ago and realized that the fundamental problem
is that pg_index depends on types oid8 and int28 (hardwired 8-element
arrays of oid and int2, respectively).  Are you going to rename these
types to oidN and int2N and make the value of N a config parameter?
Seems like a good idea ... but that magic constant 8 is buried in
a depressingly large number of places, a lot of which aren't even
symbolic constants :-(

If you do fix this, I'd suggest bumping the default N up to 16 or so;
seems like that would make a lot of people happier than N=8...
        regards, tom lane