On the dev server with updates going on in the background
administrative: 1017s
buildings_z14plus: 9360s
buildings_z13: 389s
green_areas_z13: 1908s
green_areas_z10: 20s
water_areas_z13:
water_areas_z10: 74
Roads still running, so don't have a time here.
administrative and green_areas_z13 are probably low-hanging fruit which a partial index would help with.
buildings_z14plus is very slow, and might gain from removing the ORDER BY. The additional pg_temp io capacity in production might also significantly help this.
On the dev server with updates going on in the background
Roads still running, so don't have a time here.
administrative and green_areas_z13 are probably low-hanging fruit which a partial index would help with.
buildings_z14plus is very slow, and might gain from removing the
ORDER BY
. The additional pg_temp io capacity in production might also significantly help this.