[postgis-devel] ST_Value performance

[Sandro Santilli]

On Tue, Jan 31, 2012 at 02:44:41PM -0500, Pierre Racine wrote:
> > Now I'm running an update adding the value to each of those rows, using
> > ST_Value. I do understand that over 200k calls are a lot to do, but fetching a
> > value itself shouldn't take long, right ?
> > It's a 661x313 pixels raster.
> 
> Is 40 minutes for deserializing 200000 times that raster too much? You tell me...

The same raster deserialized 200000 times for ST_PixelAsPolygon as well,
but didn't take so much.

--strk;

  ,------o-. 
  |   __/  |    Thank you for PostGIS-2.0 Topology !
  |  / 2.0 |    http://www.pledgebank.com/postgistopology
  `-o------'