[postgis-devel] Re: [postgis-users] GIST index speed

Markus Schaber schabi at logix-tt.com
Fri Jun 20 06:02:21 PDT 2008


Hi, Mark,

Mark Cave-Ayland <mark.cave-ayland at siriusit.co.uk> wrote:

> While we're at it, here's something else for the PostGIS wishlist. At 
> the moment, we perform a lot of the geometry processing using the 
> external GEOS library. This is a similar problem to TOAST in that the 
> conversion between the PostGIS geometry type and the GEOS geometry type 
> is expensive on large geometries; so if we could find some way to cache 
> the conversion results we could reap performance benefits of several 
> orders of magnitude.

I agree here.

Especially, we could cache PreparedGeometries here. (I assume that GEOS
has copied that concept from JTS.)

But it won't be easy to get the life cycle management correct.


Regards,
Markus

-- 
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org



More information about the postgis-devel mailing list