Maximum identifier lengths
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.
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, Pennsylvania 19073