From: Alessandro Baretta <a.baretta@studio.baretta.com>
To: pgsql-performance@postgresql.org
Subject: NAMEDATALEN and performance
Date: Wed, 29 Nov 2006 12:31:55 +0100
Message-ID: <456D6FAB.4030400@studio.baretta.com> (raw)
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 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. Are there commonly accepted
correlations between NAMEDATALEN and server performance? How would raising its
value impact disk usage?
[1] http://archives.postgresql.org/pgsql-hackers/2002-04/msg01253.php
--
*********************************************************************
Ing. Alessandro Baretta
Studio Baretta
http://studio.baretta.com/
Consulenza Tecnologica e Ingegneria Industriale
Technological Consulting and Industrial Engineering
Headquarters
tel. +39 02 370 111 55
fax. +39 02 370 111 54
Lab
tel. +39 02 9880 271
fax. +39 02 9828 0296
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: a.baretta@studio.baretta.com
Subject: Re: NAMEDATALEN and performance
In-Reply-To: <456D6FAB.4030400@studio.baretta.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox