Andy, Have you tweaked any of the setting in postgresql.conf or through Alter_System
See https://wiki.postgresql.org/wiki/Performance_Optimization for a list of suggestions and links to other websites. I achieved orders of magnitude increases in performance running postgis queries by changing just a few settings such as work_mem and shared_buffers. Jim
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
