Re: [SQL] 16 parameter limit

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Neil Conway <nconway(at)klamath(dot)dyndns(dot)org>
Cc: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>, peter_e(at)gmx(dot)net, pgman(at)candle(dot)pha(dot)pa(dot)us, josh(at)agliodbs(dot)com, jproctor(at)prium(dot)net, pgsql-patches(at)postgresql(dot)org
Subject: Re: [SQL] 16 parameter limit
Date: 2002-04-16 04:50:21
Message-ID: web-1372043@davinci.ethosmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches pgsql-sql

Tom,

> 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.

I disagree *very* strongly. Given that the documentation on
pg_config.h was removed from the idocs and that Pater has made noises
about removing pg_config.h entirely, it is not a substitute for
command-line configure options.

> 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.

If you can suggest a reasonable test, I will test this at 32, 64, 128
and 256 parameters to settle this issue.

-Josh

______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-04-16 05:01:33 Re: [PATCHES] [SQL] 16 parameter limit
Previous Message John Proctor 2002-04-16 04:49:21 Re: [SQL] 16 parameter limit

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2002-04-16 05:01:33 Re: [PATCHES] [SQL] 16 parameter limit
Previous Message John Proctor 2002-04-16 04:49:21 Re: [SQL] 16 parameter limit

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2002-04-16 05:01:33 Re: [PATCHES] [SQL] 16 parameter limit
Previous Message John Proctor 2002-04-16 04:49:21 Re: [SQL] 16 parameter limit