Re: [PERFORM] NAMEDATALEN and performance

2006-12-01 Thread Tom Lane
Alessandro Baretta <[EMAIL PROTECTED]> writes: > ... I would like to receive some > insight on the implications of such a choice. Beside the fact that the parser > has more work to do to decipher queries and whatnot, what other parts of the > server would be stressed by a verbose naming scheme?

Re: [PERFORM] NAMEDATALEN and performance

2006-12-01 Thread Alessandro Baretta
Tom Lane wrote: Alessandro Baretta <[EMAIL PROTECTED]> writes: I am considering the possibility of rebuilding the server with NAMEDATALEN equal to 256. I have seen an interesting thread [1] about the performance impact of raising NAMEDATALEN, but it did not seem conclusive. More to the point,

Re: [PERFORM] NAMEDATALEN and performance

2006-11-29 Thread Tom Lane
Alessandro Baretta <[EMAIL PROTECTED]> writes: > I am considering the possibility of rebuilding the server with > NAMEDATALEN equal to 256. I have seen an interesting thread [1] about > the performance impact of raising NAMEDATALEN, but it did not seem > conclusive. More to the point, tests done o

[PERFORM] NAMEDATALEN and performance

2006-11-29 Thread Alessandro Baretta
Gentlemen, I use a modeling language which compiles down to a fairly verbose SQL DDL. If I use semantically transparent identifiers in the modeling language, the compiler easily generates identifiers much longer than the default value of NAMEDATALEN. I am considering the possibility of rebuildin