with (iscachable)

Поиск
Список
Период
Сортировка
От mlw
Тема with (iscachable)
Дата
Msg-id 3BDF3AAB.31F1D4FB@mohawksoft.com
обсуждение исходный текст
Ответы Re: with (iscachable)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
We have had a few discussions about the meaning of "iscachable," and I'd like
to nag and post this again.

The current meaning of "iscachable" is to mean that it can last forever in some
persistent cache somewhere that doesn't yet exist, in practice this seems to be
just a some basic transaction level. A function without "iscachable" is called
every time it is used.

It seems there should be 3 core function cache levels:

1) "noncacheable," this should always be called every time it is used.
2) "cachable," this should mean that it will be called only once per unique set
of parameters within a transaction.
3) "persistent," this could mean it never needs to be called twice.

With the above definitions, it would make sense to have "iscacheable" as the
default for a function.

Does this make sense?


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: portability of datafiles
Следующее
От: Tom Lane
Дата:
Сообщение: Re: with (iscachable)