Re: Number of function parameter

From: Kris Jurka <books(at)ejurka(dot)com>
To: Arun Desai <Arundesai(at)kinera(dot)com>
Cc: pgsql-jdbc-list <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Number of function parameter
Date: 2003-07-21 11:32:49
Message-ID: Pine.LNX.4.33.0307210726500.8789-100000@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Arun Desai 2003-07-21 11:33:58 Re: Number of function parameter
Previous Message Kris Jurka 2003-07-21 10:23:25 Re: Number of function parameter