> > Date: Mon, 16 Jun 2008 11:06:44 +0200 (CEST) > From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> > To: pgsql-performance@postgresql.org > Subject: function difference(geometry,geometry) is SLOW! > Message-ID: > <[EMAIL PROTECTED]> > > Hi, > In my pgsql procedure, i use the function > > geometryDiff := difference > (geometry1,geometry2); > > but this function is very slow!!! > What can I do to > speed this function? > Exists a special index for it? > > Thanks in advance! > Luke
Hi, this is a postgis function. Postgis is an independent project and you might want to ask there: http://www.postgis.org/mailman/listinfo/postgis-users or http://www.faunalia.com/cgi-bin/mailman/listinfo/gfoss (italian). Anyway, as long as you just compute the difference between 2 given shapes, no index can help you. Indices speed up searches... Bye, Chris. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance