From: | mlw <markw(at)mohawksoft(dot)com> |
---|---|
To: | thomas(at)pgsql(dot)com |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL Hackers Mailing List <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: iscacheable for date/time? |
Date: | 2001-09-26 14:01:26 |
Message-ID: | 3BB1DFB6.CEB6CE8E@mohawksoft.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Thomas Lockhart wrote:
> ... and how about the istrusted attribute for various routines? Should
> it be always false or always true for C builtin functions? How about for
> builtin SQL functions which are built on top of trusted C functions? Are
> we guarding against catalog changes on the underlying C routines?
I have always had trouble with the "iscacheable" flag, there needs to be a
number of "cache" levels:
(1) cache per transaction, so you can use a function in a where statement
and it does not force a table scan. IMHO this should be the default for all
functions, but is not supported in PostgreSQL.
(2) nocache, which would mean it forces a tables scan. This is the current
default.
(3) global cache, which means the results can be stored in perpetuity, this
is the current intended meaning of iscacheable.
From | Date | Subject | |
---|---|---|---|
Next Message | Justin Clift | 2001-09-26 14:34:07 | Re: Converting from pgsql to sqlserver? |
Previous Message | Thomas Lockhart | 2001-09-26 13:24:19 | Re: iscacheable for date/time? |