Re: [postgis-users] Slow performance when selecting a geometry column

Sent:* Friday, March 18, 2016 8:59 AM >> >> *To:* PostGIS Users Discussion <postgis-users@lists.osgeo.org> >> *Subject:* Re: [postgis-users] Slow performance when selecting a >> geometry column >> >> >> >> What kind of network separates client

Re: [postgis-users] Slow performance when selecting a geometry column

ostgis-users] Slow performance when selecting a geometry column SELECT Sum(ST_NPoints(geom)) FROM thetable; On Thu, Mar 17, 2016 at 5:57 PM, David Robison <david.robi...@q-free.com<mailto:david.robi...@q-free.com>> wrote: I am having an issue with a postgis database with the time

Re: [postgis-users] Slow performance when selecting a geometry column

*From:* postgis-users [mailto:postgis-users-boun...@lists.osgeo.org > <postgis-users-boun...@lists.osgeo.org>] *On Behalf Of *David Robison > *Sent:* Friday, March 18, 2016 6:14 AM > *To:* PostGIS Users Discussion <postgis-users@lists.osgeo.org> > *Subject:* Re: [postgis-users]

Re: [postgis-users] Slow performance when selecting a geometry column

SELECT Sum(ST_NPoints(geom)) FROM thetable; On Thu, Mar 17, 2016 at 5:57 PM, David Robison 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

Re: [postgis-users] Slow performance when selecting a geometry column

...@lists.osgeo.org] On Behalf Of Nordgren, Bryce L -FS Sent: Friday, March 18, 2016 8:59 AM To: PostGIS Users Discussion <postgis-users@lists.osgeo.org> Subject: Re: [postgis-users] Slow performance when selecting a geometry column What kind of network separates client and server? Conservatively as

Re: [postgis-users] Slow performance when selecting a geometry column

ers@lists.osgeo.org> Subject: Re: [postgis-users] Slow performance when selecting a geometry column So there is a total of over 560,000 points in the 8000 records returned. I would have assumed that it was simply returning the contents of the geometry column and that the number of points (albeit they t

[postgis-users] Slow performance when selecting a geometry column

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