Greets,

Will Postgres suffer any major performance hits from
recomiling with support for column names over 32 chars.
ie: 64 chars.

Jeff


======================================================
Jeff MacDonald
	jeff@pgsql.com	irc: bignose on EFnet
======================================================


Mon, 7 Feb 2000 10:24:24 -0400 (AST)
"Jeff MacDonald <jeff@pgsql.com>" <jeffm@pgsql.com>
Longer Column Names
"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

Mon, 07 Feb 2000 11:06:23 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Longer Column Names 
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 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
> 
> ************
> 


Mon, 7 Feb 2000 14:20:06 -0400 (AST)
"Jeff MacDonald <jeff@pgsql.com>" <jeffm@pgsql.com>
Re: [HACKERS] Longer Column Names 
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


Tue, 8 Feb 2000 00:13:01 +0100 (CET)
Peter Eisentraut <peter_e@gmx.net>
Re: [HACKERS] Longer Column Names 