[postgis-devel] Implement New Geometry Index Method?

[Alexander Korotkov]

On Wed, May 21, 2014 at 1:02 PM, Jeremy Palmer <JPalmer at linz.govt.nz> wrote:

>  Hi PostGIS Devs,
>
>
>
> I have a daily process that I would like to optimise. The process includes
> a spatial intersects join between a small administration boundaries table
> for New Zealand that contains large geometries (100,000+ points per
> polygon) and a large dataset with small line strings.
>
>
>
> The first iteration of SQL I developed for the process I used standard
> join (WHERE ST_Interesects(admin.geom, other.geom)) and it took 4 hours to
> complete. No spatial index was used. Not acceptable.
>

So, your task is so-called "spatial join". We are now doing researches on
it. It would be nice if you could share your dataset so we can do
experiments on it.

------
With best regards,
Alexander Korotkov.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20140521/a25e0b44/attachment.html>