pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: giuseppe.derossi@email.it
To: pgsql-admin@postgresql.org
Subject: geometry poligons performance and index
Date: Wed, 29 Aug 2007 08:54:45 +0200
Message-ID: <77edfa82157a698e4c207fcdaccc52f2@164.129.1.43> (raw)

 
 Hi
 I need to set a query which performs a intersection check between two set
of
 polygons which are stored into two tables.
 I wrote the where instruction so:
 ...
 where area(intersection(t1.the_geom,t2.the_geom))>0
 ...
 
 The results are ok, but the query is too slow. I tried to applay a GIST and
 gtree index but performance did not improve.
 By explaining the query I see that the where condition gets the query slow.
 Is there a more simple way to check if two poligons have a not null
 intersection (they overlap)?
 
 Is there a kind of index I can use ?
 
 THanks
 
 Giu 
  
 --
 Email.it, the professional e-mail, gratis per te: http://www.email.it/f
 
 Sponsor:
 Vuoi un prestito fino a 30.000 Euro? Clicca qui per un preventivo
immediato! Prometeo ti propone prestiti personali senza attese e senza
spese.
 Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=6915&d=20070829





view thread (4+ messages)  latest in thread

Message-ID: <77edfa82157a698e4c207fcdaccc52f2@164.129.1.43>
Permalink:  ../77edfa82157a698e4c207fcdaccc52f2@164.129.1.43/
Also on:    postgresql.org/message-id/77edfa82157a698e4c207fcdaccc52f2@164.129.1.43

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: giuseppe.derossi@email.it
  Subject: Re: geometry poligons performance and index
  In-Reply-To: <77edfa82157a698e4c207fcdaccc52f2@164.129.1.43>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox