Re: Number of function parameter - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Number of function parameter
Date
Msg-id Pine.LNX.4.33.0307210726500.8789-100000@leary.csoft.net
Whole thread Raw
In response to Re: Number of function parameter  ("Arun Desai" <Arundesai@kinera.com>)
List pgsql-jdbc

On Mon, 21 Jul 2003, Arun Desai wrote:

> Kris,
>         Would it have any implication on the database in terms of
> performance etc.,. if I change INDEX_MAX_KEYS to a number greater than 32,
> compile the sources and run the database?
>

Yes, otherwise it would be set to a higher value.  That said the
performance decrease shouldn't be that bad.  The following tests were made
during the change from 16 to 32 and are supposed to demonstrate the worst
case scenario, fast functions being invoked many times.  I couldn't say
what the real world impact to you is.


http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&frame=right&rnum=11&thl=1190037072,1190014321,1189977929,1189879040,1189866197,1189843487,1189825930,1189700130,1189693906,1189683897,1189678002,1189640255&seekm=20020802140556.Q8966%40mail.libertyrms.com#link16

Kris Jurka




pgsql-jdbc by date:

Previous
From: "Arun Desai"
Date:
Subject: Re: Number of function parameter
Next
From: Fernando Nasser
Date:
Subject: Re: Prepared Statements