[postgis-users] performace question

[Paul Ramsey]

Can you share your data with me? I'm interested to profile and see
where the bottleneck actually is.

P.

On Wed, Apr 1, 2009 at 9:50 AM, Martin Landa <landa.martin at gmail.com> wrote:
> Hi,
>
> 2009/4/1  <geniaux at avignon.inra.fr>:
>> 3) use "SELECT count(obce.gid) FROM obce,cr WHERE  obce.the_geom && cr.the_geom
>> and ST_Touches(obce.the_geom,cr.the_geom);"
>
> it will not help, all polygons from 'obce' are inside of 'cr' - I just
> want to select those polygons from 'obce' (multipolygon) which share
> with boundary of 'cr' (linestring) at least one point.
>
> M.
>
> --
> Martin Landa <landa.martin gmail.com> * http://gama.fsv.cvut.cz/~landa
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>