[PERFORM] function difference(geometry,geometry) is SLOW!

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 -- Sent via pgsql-performance mailing list

[PERFORM] Tsearch2 Initial Search Speed

Hi, I am looking to improve the initial query speed for the following query: select email_id from email, to_tsquery('default','example') as q where q@@fts; This is running on 8.2.4 on Windows Server 2K3. The initial output from explain analyse is as follows. Nested Loop (cost=8.45..76.70

Re: [PERFORM] Tsearch2 Initial Search Speed

On Monday 16 June 2008, Howard Cole [EMAIL PROTECTED] wrote: Hi, I am looking to improve the initial query speed for the following query: select email_id from email, to_tsquery('default','example') as q where q@@fts; This is running on 8.2.4 on Windows Server 2K3. The initial output from

Re: [PERFORM] [pgsql-performance] function difference(geometry,geometry) is SLOW!

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