PostgreSQL 9.5.1 with PostGIS 2.0 extension
This query is taking > 15 min to run:
with cte_dumppoly as (select (st_dump(geom)).geom as geom, dccode from public."BJW49"), cte_intersection as (select st_intersection(a.geom,b.geom) as geom from public.streets a, cte_dumppoly b where st_intersects(a.geom,b.geom)) select st_buffer(geom::geography, 15.24)::geometry as geom from cte_intersection
I'm just trying to buffer the intersecting streets by 15.24 meters. Any suggestions to speed this up?
info on data:
select st_area(geom::geography, true) from public."BJW49" = 24,878,964 sum(st_npoints(geom)) from public."BJW49" = 723,788 select sum(st_npoints(geom)) from public.streets; = 6,287,548
I've already created indexed/clustered/vacuumed/analyzed the tables FYI.