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@ejurka.com>
To: "Arun Desai" <Arundesai@kinera.com>
Cc: "pgsql-jdbc-list" <pgsql-jdbc@postgresql.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