On Mon, Mar 2, 2020 at 1:16 PM Alexandre Neto <senhor.n...@gmail.com> wrote:
>
> Stating the obvious,
>
> Do you have a spatial index on your geom column?
That will make no difference, the query is reading the whole contents
of the column, a spatial index will do nothing.
P
>
> 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
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
