Re: optimiser STABLE vs. temp table was: HOWTO caching data across function calls: temporary tables, cursor?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: optimiser STABLE vs. temp table was: HOWTO caching data across function calls: temporary tables, cursor?
Дата
Msg-id 2651.1207063340@sss.pgh.pa.us
обсуждение исходный текст
Ответ на optimiser STABLE vs. temp table was: HOWTO caching data across function calls: temporary tables, cursor?  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
Ответы Re: optimiser STABLE vs. temp table was: HOWTO caching data across function calls: temporary tables, cursor?  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
Список pgsql-general
Ivan Sergio Borgonovo <mail@webthatworks.it> writes:
> I can't really appreciate the difference... or better... I think the
> difference may be that I can't take for granted the function will be
> cached if I delegate the choice to the optimiser.

You can take for granted that it won't be, because there is no function
cache in Postgres.

            regards, tom lane

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

Предыдущее
От: "Pettis, Barry"
Дата:
Сообщение: Re: Using tables in other PostGreSQL database
Следующее
От: Sam Mason
Дата:
Сообщение: Re: Using tables in other PostGreSQL database