Thread: Maximum identifier lengths

Maximum identifier lengths

From
Thomas Swan
Date:
The 7.4 release increased the maximum length for column and table 
identifiers to 64 characters.   Are there any plans to increase the 
maximum length out to the SQL spec of 128 characters?   I remembered 
some performance penalties for the longer name lengths for hash joins 
but I don't know if any of the many improvements for the 8.0 release 
have change or reduced the penalties for such identifiers.


Re: Maximum identifier lengths

From
Bruce Momjian
Date:
Thomas Swan wrote:
> The 7.4 release increased the maximum length for column and table 
> identifiers to 64 characters.   Are there any plans to increase the 
> maximum length out to the SQL spec of 128 characters?   I remembered 
> some performance penalties for the longer name lengths for hash joins 
> but I don't know if any of the many improvements for the 8.0 release 
> have change or reduced the penalties for such identifiers.

I have heard no discussion of increasing it, certainly not for 8.0, and
I don't think we have changed anything that would affect the performance
penalty.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073