Re: [PATCHES] [SQL] 16 parameter limit

From: Hannu Krosing <hannu(at)tm(dot)ee>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, Neil Conway <nconway(at)klamath(dot)dyndns(dot)org>, Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, josh(at)agliodbs(dot)com, jproctor(at)prium(dot)net, PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [PATCHES] [SQL] 16 parameter limit
Date: 2002-04-16 19:12:52
Message-ID: 1018984377.14960.28.camel@taru.tm.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches pgsql-sql

On Tue, 2002-04-16 at 07:01, Tom Lane wrote:
> Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> > How about this: We store the first 16 parameters in some fixed array for
> > fast access like now, and when you have more than 16 then 17 and beyond
> > get stored in some variable array in pg_proc.
>
> <<itch>> What's this going to cost us in the function lookup code paths?
>
> If we can do it with little or no performance cost (at least for the
> "normal case" of fewer-than-N parameters) then I'm all ears.

Perhaps we could use the 16-th element as an indicator of 16-or-more
args. If it is 0 then there are <= 15 args if it is something else, then
this something else is hash of extra argument types that need to be
looked up separately.

Of course we will need some way of resolving multiple hash matches.

--------------
Hannu

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Hannu Krosing 2002-04-16 19:18:31 Re: multibyte support by default
Previous Message Zeugswetter Andreas SB SD 2002-04-16 18:51:33 Re: Implicit coercions need to be reined in

Browse pgsql-patches by date

  From Date Subject
Next Message Neil Conway 2002-04-16 20:27:17 regression tests for ALTER TABLE ... DEFAULT
Previous Message Bruce Momjian 2002-04-16 16:59:55 Re: [HACKERS] YADP - Yet another Dependency Patch

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2002-04-17 04:32:40 Re: help - JOIN problem
Previous Message Neil Conway 2002-04-16 16:04:37 Re: [SQL] 16 parameter limit