[postgis-users] st_union

[Alexandre Neto]

Stating the obvious,

Do you have a spatial index on your geom column?

Alexandre Neto

A segunda, 2/03/2020, 17:04, Paul Ramsey <pramsey at cleverelephant.ca>
escreveu:

> No, if it’s returning the answer you want, that’s the way to do it, and
> there’s no way around it.
>
> > On Mar 2, 2020, at 6:25 AM, <paul.malm at lfv.se> <paul.malm at lfv.se> wrote:
> >
> > Hi list,
> > I would like to do this:
> > CREATE TABLE public."Areas_union" AS select
> (st_dump(st_union("the_geom"))).geom from "Areas";
> >
> > But it takes such a long time to execute, is there a smarter way to do
> it?
> >
> > Kind regards,
> > Paul
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at lists.osgeo.org
> > https://lists.osgeo.org/mailman/listinfo/postgis-users
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200302/be1770c4/attachment.html>