Thread: Longer Column Names
Greets, Will Postgres suffer any major performance hits from recomiling with support for column names over 32 chars. ie: 64 chars. Jeff ====================================================== Jeff MacDonaldjeff@pgsql.com irc: bignose on EFnet ======================================================
"Jeff MacDonald <jeff@pgsql.com>" <jeffm@pgsql.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
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) 2: will it require and initdb , backup, reinstall . or just recompilie and let her rip. jeff ====================================================== Jeff MacDonaldjeff@pgsql.com irc: bignose on EFnet ====================================================== On Mon, 7 Feb 2000, Tom Lane wrote: > "Jeff MacDonald <jeff@pgsql.com>" <jeffm@pgsql.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 > > ************ >
On 2000-02-07, Jeff MacDonald <jeff@pgsql.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@pgsql.com irc: bignose on EFnet > ====================================================== > > On Mon, 7 Feb 2000, Tom Lane wrote: > > > "Jeff MacDonald <jeff@pgsql.com>" <jeffm@pgsql.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@gmx.net 75262 Uppsala http://yi.org/peter-e/ Sweden