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 > > geometryDif

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 ou

[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 r

[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 (pgsql-performance@postgre