[postgis-devel] reuse/caching of values in a query

Paul Ramsey pramsey at cleverelephant.ca
Wed Jul 8 14:59:00 PDT 2009


On Wed, Jul 8, 2009 at 12:56 PM, <nicklas.aven at jordogskog.no> wrote:
> I'm I wrong thinking it is an important matter for postgis as a
> calculation-intence part of the postgresql-world?

Maybe, maybe not. More to the point, is it the biggest performance
fish to fry? For example, implementing a prepared distance operation
might save more CPU cycles over the population of PostGIS use cases.

In any event, re-using function results is certainly a PgSQL core
problem, not ours. I actually thought that having a marked the
function as immutable gave us some of effect, but perhaps not.

P



More information about the postgis-devel mailing list