Received: from localhost (unknown [200.46.204.183])
	by developer.postgresql.org (Postfix) with ESMTP id 313D12E0031
	for <pgsql-performance-postgresql.org@developer.postgresql.org>;
	Mon, 16 Jun 2008 06:06:51 -0300 (ADT)
Received: from developer.postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 10612-10
	for <pgsql-performance-postgresql.org@developer.postgresql.org>;
	Mon, 16 Jun 2008 06:06:44 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from cp-out4.libero.it (cp-out4.libero.it [212.52.84.104])
	by developer.postgresql.org (Postfix) with ESMTP id 00FE62E0033
	for <pgsql-performance@postgresql.org>;
	Mon, 16 Jun 2008 06:06:46 -0300 (ADT)
Received: from wmail4.libero.it (172.31.0.147) by cp-out4.libero.it (8.5.014)
	id 4832F8AE01D5A570 for pgsql-performance@postgresql.org;
	Mon, 16 Jun 2008 11:06:44 +0200
Message-ID: <10574478.390451213607204584.JavaMail.defaultUser@defaultHost>
Date: Mon, 16 Jun 2008 11:06:44 +0200 (CEST)
From: "luke.78@libero.it" <luke.78@libero.it>
Reply-To: "luke.78@libero.it" <luke.78@libero.it>
To: pgsql-performance@postgresql.org
Subject: function difference(geometry,geometry) is SLOW!
MIME-Version: 1.0
Content-Type: text/plain;charset="UTF-8"
Content-Transfer-Encoding: 7bit
X-SenderIP: 217.169.121.9
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level: 
X-Archive-Number: 200806/55
X-Sequence-Number: 30405

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