Postgres Pro
Downloads
Home   >   mailing lists

Re: Is there a drawback when changing NAMEDATALEN to 64? - Mailing list pgsql-general

From Tom Lane
Subject Re: Is there a drawback when changing NAMEDATALEN to 64?
Date
Msg-id 21109.1011916392@sss.pgh.pa.us
Whole thread Raw
In response to Is there a drawback when changing NAMEDATALEN to 64?  (Frank Joerdens <frank@joerdens.de>)
Responses Re: Is there a drawback when changing NAMEDATALEN to 64?  (Bill McGonigle <mcgonigle@medicalmedia.com>)
List pgsql-general
Tree view 
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> TODO updated:

> * Increase identifier length (NAMEDATALEN) if small performance hit;
>   change struct pgNotify to use pid first, breaks notify API

BTW, I noticed the other day that both SQL92 and SQL99 specify the
maximum identifier length as 128.  So really there is a standardization
argument for pushing it up to 128 ...

            regards, tom lane

pgsql-general by date:

Previous
From: "Tim Barnard"
Date:
Subject: Simple 'type' question
Next
From: Bruce Momjian
Date:
Subject: Re: Is there a drawback when changing NAMEDATALEN to 64?