How do you control IMMUTABLE PG PROC results?

Поиск
Список
Период
Сортировка
От Carlo Stonebanks
Тема How do you control IMMUTABLE PG PROC results?
Дата
Msg-id iaviq7$27dh$1@news.hub.org
обсуждение исходный текст
Ответы Re: How do you control IMMUTABLE PG PROC results?  (Leif Biberg Kristensen <leif@solumslekt.org>)
Re: How do you control IMMUTABLE PG PROC results?  (hubert depesz lubaczewski <depesz@depesz.com>)
Список pgsql-general
Дерево обсуждения 
We have procs that would benefit from returning IMMUTABLE results. The procs
are dependent on external tables that rarely change, but when they DO
change, it would be great if we could expire the cache that the procs read
from so that the procs are forced to re-evaluate the results.

Is this possible?

How do I know how many possible results are cached?

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: select to_char(current_timestamp, 'YYYY-WW');
Следующее
От: Alexander Farber
Дата:
Сообщение: Re: select to_char(current_timestamp, 'YYYY-WW');