Postgres Pro
Downloads
Home   >   mailing lists

function difference(geometry,geometry) is SLOW! - Mailing list pgsql-performance

From luke.78@libero.it
Subject function difference(geometry,geometry) is SLOW!
Date
Msg-id 10574478.390451213607204584.JavaMail.defaultUser@defaultHost
Whole thread Raw
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: "Gavin M. Roy"
Date:
Subject: Re: how to find the sql using most of the i/o in an oltp system
Next
From: Howard Cole
Date:
Subject: Tsearch2 Initial Search Speed