SQL plan in functions

Поиск
Список
Период
Сортировка
От Julius Tuskenis
Тема SQL plan in functions
Дата
Msg-id 494A1551.3010701@gmail.com
обсуждение исходный текст
Ответы Re: SQL plan in functions
Re: SQL plan in functions
Список 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


В списке pgsql-general по дате отправления:

Предыдущее
От: "Jonatan Evald Buus"
Дата:
Сообщение: Re: Prevent new timeline during archive recovery
Следующее
От: "Grzegorz Jaśkiewicz"
Дата:
Сообщение: Re: SQL plan in functions