From: Tom Lane <tgl@sss.pgh.pa.us>
To: Neil Conway <nconway@klamath.dyndns.org>
Cc: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Cc: peter_e@gmx.net
Cc: pgman@candle.pha.pa.us
Cc: josh@agliodbs.com
Cc: jproctor@prium.net
Cc: pgsql-patches@postgresql.org
Subject: Re: [SQL] 16 parameter limit
Date: Tue, 16 Apr 2002 00:13:31 -0400
Message-ID: <9110.1018930411@sss.pgh.pa.us> (raw)
In-Reply-To: <20020415235216.5bdf393a.nconway@klamath.dyndns.org>
References: <Pine.LNX.4.30.0204152332040.834-100000@peter.localdomain>
<GNELIHDDFBOCMGBFGEFOKECGCCAA.chriskl@familyhealth.com.au>
<20020415235216.5bdf393a.nconway@klamath.dyndns.org>
Neil Conway <nconway@klamath.dyndns.org> writes:
> My vote is to set the default # of function args to some
> reasonable default (32 sounds good), and leave it at that.
Bear in mind that s/32/16/ gives you the exact state of the discussion
when we raised the limit from 8 to 16 ;-)
Still, I do not really see the value of adding a configure argument.
Anyone who can't figure out how to tweak this in pg_config.h is probably
not ready to run a non-default configuration anyhow.
If the consensus is to raise the default from 16 to 32, I won't object.
Beyond that, I'd start asking questions about who's measured the
performance hit and what they found.
On the NAMEDATALEN part of the argument: SQL92 clearly expects that
NAMEDATALEN should be 128. But the first report of the performance
cost looked rather grim. Has anyone retried that experiment since
we tweaked hashname to not hash all the trailing zeroes?
regards, tom lane
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-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, nconway@klamath.dyndns.org, chriskl@familyhealth.com.au, peter_e@gmx.net, pgman@candle.pha.pa.us, josh@agliodbs.com, jproctor@prium.net, pgsql-patches@postgresql.org
Subject: Re: [SQL] 16 parameter limit
In-Reply-To: <9110.1018930411@sss.pgh.pa.us>
* 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