Re: SQL plan in functions - Mailing list pgsql-general

From Grzegorz Jaśkiewicz
Subject Re: SQL plan in functions
Date
Msg-id 2f4958ff0812180121x4bf637em39db2a3ba63a9044@mail.gmail.com
Whole thread Raw
In response to SQL plan in functions  (Julius Tuskenis <julius.tuskenis@gmail.com>)
List pgsql-general
On Thu, Dec 18, 2008 at 9:18 AM, Julius Tuskenis
<julius.tuskenis@gmail.com> wrote:
> Hello, list.
>
> I have a function witch returns record set. What troubles me is that
> depending on parameters I pass to this function  the execution time varies
> greatly. On the other hand if I execute the query (not the function) with
> pgAdmin  - it gives results quickly.
> In previous post You helped me realize, that the problem was because the
> function has only one plan of SQL inside no matter the parameters values. Is
> there a way to order postgres to check the plan each time the function is
> called?

use EXECUTE 'query' .



--
GJ

pgsql-general by date:

Previous
From: Julius Tuskenis
Date:
Subject: SQL plan in functions
Next
From: "A. Kretschmer"
Date:
Subject: Re: SQL plan in functions