-users-boun...@lists.osgeo.org> on behalf of Rémi
Cura <remi.c...@gmail.com>
Reply-To: PostGIS Users Discussion <postgis-users@lists.osgeo.org>
Date: Saturday, February 4, 2017 at 11:23 AM
To: PostGIS Users Discussion <postgis-users@lists.osgeo.org>
Subject: Re: [postgis-users] ST_value slow
Date: Saturday, February 4, 2017 at 3:01 AM
To: PostGIS Users Discussion <postgis-users@lists.osgeo.org>
Subject: Re: [postgis-users] ST_value slow
Hey,
I suppose your raster is correctly cut into small pieces.
You should first try to clock one point value retrieval.
It should be &l
Hey,
I suppose your raster is correctly cut into small pieces.
You should first try to clock one point value retrieval.
It should be < 50ms (or you have an index issue)
Then you could force the use of index by writting a function
update_one_point(point) $$ update XXX set XXX WHERE