Re: Number of function parameter

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?

Thanks,
Arun Desai.

----- Original Message -----
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>
Sent: Monday, July 21, 2003 3:53 PM
Subject: Re: [JDBC] Number of function parameter

>
>
> On Mon, 21 Jul 2003, Arun Desai wrote:
>
> > Hi,
> > Why is that there is a maximum limit of 32 input parameters to the
> > Postgresql function?
>
> The backend's internals are limited in this way. If you compile from
> source you can change this limit by altering INDEX_MAX_KEYS. Search the
> archives for more details.
>
> Kris Jurka
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match