Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 325D2474E42 for ; Tue, 16 Apr 2002 01:02:36 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id g3G51XF09409; Tue, 16 Apr 2002 01:01:34 -0400 (EDT) To: Peter Eisentraut Cc: Neil Conway , Christopher Kings-Lynne , Bruce Momjian , josh@agliodbs.com, jproctor@prium.net, PostgreSQL Development Subject: Re: [PATCHES] [SQL] 16 parameter limit In-reply-to: References: Comments: In-reply-to Peter Eisentraut message dated "Tue, 16 Apr 2002 00:36:11 -0400" Date: Tue, 16 Apr 2002 01:01:33 -0400 Message-ID: <9406.1018933293@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200204/777 X-Sequence-Number: 21441 Peter Eisentraut 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. <> 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. regards, tom lane