Re: Is 7.3 a good time to increase NAMEDATALEN ?

> -----Original Message-----
> From: Neil Conway [mailto:nconway(at)klamath(dot)dyndns(dot)org]
> Sent: Tuesday, May 21, 2002 12:19 PM
> To: Joel Burton
> Cc: pgsql-hackers(at)postgresql(dot)org
> Subject: Re: [HACKERS] Is 7.3 a good time to increase NAMEDATALEN ?
>
>
> On Tue, 21 May 2002 11:41:26 -0400
> "Joel Burton" <joel(at)joelburton(dot)com> wrote:
> > Noticed that increasing NAMEDATALEN to 128 is still on the TODO.
>
> The last benchmarks I saw indicate that there's still a significant
> performance hit when increasing NAMEDATALEN, whether to 64 or 128.
>
> Given that only a small percentage of PostgreSQL users need long
> identifiers, and *everyone* would suffer the performance hit, I'd
> rather that we not touch NAMEDATALEN until more work has been
> done on attempting to reduce the performance penalty.
>
> Until then, the people who absolutely, positively must have long
> identifiers can just raise NAMEDATALEN themselves.

I'm sure that this is an idiotic thing to say, but why not just make it
varchar?

Most of the time the database objects will be small (maybe 10 characters
on average) but sometimes you want them to be really large.