[postgis-users] performance of intersects(a,b)

[Willy-Bas Loos]

Hi Kis,
I don't think the GiST index has anything to do with this, i'm only
processing one record.
thx,
WBL

On Thu, Feb 21, 2008 at 7:47 AM, Kis János Tamás <kjt at takarnet.hu> wrote:

> csütörtök 14 február 2008 15.11 dátummal Willy-Bas Loos ezt írta:
> >
> > select 'yes' as foo
> > from table1 a, table1 b
> > where a.gid=4
> > and b.gid=4
> > and intersects(a.the_geom, b.the_geom)
> >
>
> Did you try the next procedure?
>
> create index i_a on table1  usng gist the_geom;
> create index i_b on table2  usng gist the_geom;
>
> select 'yes' as foo
> from table1 a, table1 b
> where a.gid=4
>    and b.gid=4
>     and a.the_geom && b.the_geom
>     and intersects(a.the_geom, b.the_geom)
>
> Regards,
> kjt
>
>
> McAfee SCM 4.1 által ellenőrizve!
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080223/8ddae6f4/attachment.html>