Re: [HACKERS] Longer Column Names

On 2000-02-07, Jeff MacDonald <jeff(at)pgsql(dot)com> mentioned:

> Ok sounds good then. got a few questions..
>
> 1: how to change this (i assume it's in the source, and not a
> configure otpion)

in src/include/postgres_ext.h the macro NAMEDATALEN

>
> 2: will it require and initdb , backup, reinstall . or just
> recompilie and let her rip.

Oh yeah, the whole deal. See also comments near the above location.

>
> jeff
>
>
> ======================================================
> Jeff MacDonald
> jeff(at)pgsql(dot)com irc: bignose on EFnet
> ======================================================
>
> On Mon, 7 Feb 2000, Tom Lane wrote:
>
> > "Jeff MacDonald <jeff(at)pgsql(dot)com>" <jeffm(at)pgsql(dot)com> writes:
> > > Will Postgres suffer any major performance hits from
> > > recomiling with support for column names over 32 chars.
> > > ie: 64 chars.
> >
> > I doubt it'd make a large difference, except that your system
> > tables would get bigger. Try it and let us know what you see...
> >
> > regards, tom lane
> >
> > ************
> >
>
>
> ************
>
>

--
Peter Eisentraut Sernanders väg 10:115
peter_e(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden