I am having an issue with a postgis database with the time it takes to query the geometry column. The query selects 8000 records. The time to retrieve the records when not returning the geometry column is about 100ms. However, the time for the same query when requesting the geometry column takes about 9 seconds. Any thoughts on how I can improve the performance reading the geometry column from a postgis database? I am using PostgreSQL 9.4 and Postgis 22.1. Thanks, David
David Robison Principal System Engineer O. +1 757 546 3401 M. +1 757 286 0022 david.robi...@q-free.com<mailto:david.robi...@q-free.com> www.q-free.com/openroads<http://www.q-free.com/openroads> Q-Free Open Roads 103 Watson Road Chesapeake VA 23320 [cid:image002.png@01D15905.23A1F460] ________________________________ This email communication (including any attachments) may contain confidential and/or privileged material intended solely for the individual or entity to which it is addressed. If you are not the intended recipient, please delete this email immediately.
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/postgis-users