Stating the obvious,
Do you have a spatial index on your geom column?
Alexandre Neto
A segunda, 2/03/2020, 17:04, Paul Ramsey <pram...@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.m...@lfv.se> <paul.m...@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@lists.osgeo.org
> > https://lists.osgeo.org/mailman/listinfo/postgis-users
>
> _______________________________________________
> postgis-users mailing list
> postgis-users@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
