Re: Is 7.3 a good time to increase NAMEDATALEN ?

From: Neil Conway <nconway(at)klamath(dot)dyndns(dot)org>
To: "Joel Burton" <joel(at)joelburton(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Is 7.3 a good time to increase NAMEDATALEN ?
Date: 2002-05-21 19:19:16
Message-ID: 20020521151916.150c1f6f.nconway@klamath.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, 21 May 2002 11:41:26 -0400
"Joel Burton" <joel(at)joelburton(dot)com> wrote:
> Noticed that increasing NAMEDATALEN to 128 is still on the TODO.

The last benchmarks I saw indicate that there's still a significant
performance hit when increasing NAMEDATALEN, whether to 64 or 128.

Given that only a small percentage of PostgreSQL users need long
identifiers, and *everyone* would suffer the performance hit, I'd
rather that we not touch NAMEDATALEN until more work has been
done on attempting to reduce the performance penalty.

Until then, the people who absolutely, positively must have long
identifiers can just raise NAMEDATALEN themselves.

Cheers,

Neil

--
Neil Conway <neilconway(at)rogers(dot)com>
PGP Key ID: DB3C29FC

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Dave Page 2002-05-21 19:24:46 Re: More schema queries
Previous Message Trond Eivind Glomsrød 2002-05-21 19:09:34 Re: Redhat 7.3 time manipulation bug