root <ffabrizio(at)mmrd(dot)com> writes:
> I'm running PostgreSQL 7.1.3, and I have a query that uses one of my
> functions:
> select findregion(entityid) from msg200;
> The findregion function is set to be 'with (iscachable)'. However, the
> query takes upwards of 40 seconds to run, the first time and every time
> thereafter, consistently. It doesn't seem like the caching is working.
I'm not sure what you think "iscachable" does ... but there certainly is
not a cache that remembers the results of functions across statements.
regards, tom lane