Re: Is there a drawback when changing NAMEDATALEN to 64?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Frank Joerdens <frank(at)joerdens(dot)de>, pgsql-general(at)postgresql(dot)org
Subject: Re: Is there a drawback when changing NAMEDATALEN to 64?
Date: 2002-01-24 23:53:12
Message-ID: 21109.1011916392@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tim Barnard 2002-01-25 00:11:23 Re: Simple 'type' question
Previous Message Tom Lane 2002-01-24 23:51:03 Re: Simple 'type' question