function difference(geometry,geometry) is SLOW!

From: "luke(dot)78(at)libero(dot)it" <luke(dot)78(at)libero(dot)it>
To: pgsql-performance(at)postgresql(dot)org
Subject: function difference(geometry,geometry) is SLOW!
Date: 2008-06-16 09:06:44
Message-ID: 10574478.390451213607204584.JavaMail.defaultUser@defaultHost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Browse pgsql-performance by date

  From Date Subject
Next Message Howard Cole 2008-06-16 17:55:43 Tsearch2 Initial Search Speed
Previous Message Gavin M. Roy 2008-06-15 14:53:06 Re: how to find the sql using most of the i/o in an oltp system