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
.
Bryce
From: postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] On Behalf Of
David Robison
Sent: Friday, March 18, 2016 6:14 AM
To: PostGIS Users Discussion
mailto:postgis-users@lists.osgeo.org>>
Subject: Re: [postgis-users] Slow performance when selecting a geometry column
So ther
selecting a geometry column
SELECT Sum(ST_NPoints(geom)) FROM thetable;
On Thu, Mar 17, 2016 at 5:57 PM, David Robison
mailto:david.robi...@q-free.com>> wrote:
I am having an issue with a postgis database with the time it takes to query
the geometry column. The query selects 8000 record