[postgis-users] Performance question (how many years will this take?)

[Paul Ramsey]

Wood Brent wrote:

> select into...
> ...
> ...
> where intersects(uniq_event.the_geom, chat_cells3.the_geom);

Is that really your where clause? You want this:

   where intersects(uniq_event.the_geom, chat_cells3.the_geom)
   and uniq_event.the_geom && chat_cells3.the_geom

So that the spatial index cuts down on the number of comparisons that 
have to be made with the expensive exact intersects() function.

-- 
       __
      /
      | Paul Ramsey
      | Refractions Research
      | Email: pramsey at refractions.net
      | Phone: (250) 885-0632
      \_