[postgis-users] Speed up query
mabewlun at gmail.com
Wed Oct 19 09:28:26 PDT 2011
On 19 October 2011 18:21, Gheorghiu, Mihai <mgheorghiu at chpmail.com> wrote:
> I have a query that places points in polygons:
> insert into results (
> select a.point_id, b.polygon_id
> from points a, polygons b
> = 't'
> There are ~1M points and ~300k polygons. There are geo indexes on the geog
> columns of both tables.
> What changes would make the query faster?
> Thank you very much.
... and the problem is?
Especially I'd like to know is the time, show us explain analyze of the
query and show table structures.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the postgis-users