Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patchespgsql-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

pgsql-hackers by date

Next:From: Tom LaneDate: 2002-04-16 05:01:33
Subject: Re: [PATCHES] [SQL] 16 parameter limit
Previous:From: John ProctorDate: 2002-04-16 04:49:21
Subject: Re: [SQL] 16 parameter limit

pgsql-patches by date

Next:From: Tom LaneDate: 2002-04-16 05:01:33
Subject: Re: [PATCHES] [SQL] 16 parameter limit
Previous:From: John ProctorDate: 2002-04-16 04:49:21
Subject: Re: [SQL] 16 parameter limit

pgsql-sql by date

Next:From: Tom LaneDate: 2002-04-16 05:01:33
Subject: Re: [PATCHES] [SQL] 16 parameter limit
Previous:From: John ProctorDate: 2002-04-16 04:49:21
Subject: Re: [SQL] 16 parameter limit

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group