SELECT Sum(ST_NPoints(geom)) FROM thetable; On Thu, Mar 17, 2016 at 5:57 PM, David Robison <[email protected]> wrote:
> 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 > > [email protected] > > www.q-free.com/openroads > > [image: cid:[email protected]] > > *Q-Free Open Roads* > > 103 Watson Road > > Chesapeake VA 23320 > > [image: cid:[email protected]] > > [image: cid:[email protected]] > ------------------------------ > > 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 > [email protected] > http://lists.osgeo.org/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/postgis-users
