On Thu, Dec 18, 2008 at 9:18 AM, Julius Tuskenis <julius.tuskenis@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
