with (iscachable)

From: mlw <markw(at)mohawksoft(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: with (iscachable)
Date: 2001-10-30 23:41:31
Message-ID: 3BDF3AAB.31F1D4FB@mohawksoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-10-31 00:37:26 Re: with (iscachable)
Previous Message Tom Lane 2001-10-30 23:14:07 Re: portability of datafiles