with (iscachable) - Mailing list pgsql-hackers

From mlw
Subject with (iscachable)
Date
Msg-id 3BDF3AAB.31F1D4FB@mohawksoft.com
Whole thread Raw
Responses Re: with (iscachable)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: portability of datafiles
Next
From: Tom Lane
Date:
Subject: Re: with (iscachable)