SQL plan in functions

From: Julius Tuskenis <julius(dot)tuskenis(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: SQL plan in functions
Date: 2008-12-18 09:18:09
Message-ID: 494A1551.3010701@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

--
Julius Tuskenis

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jonatan Evald Buus 2008-12-18 09:18:13 Re: Prevent new timeline during archive recovery
Previous Message Chris 2008-12-18 08:10:24 Re: text_soundex function