[postgis-devel] ST_Value performance

[Sandro Santilli]

On Tue, Jan 31, 2012 at 09:11:16PM +0100, Sandro Santilli wrote:
> On Tue, Jan 31, 2012 at 02:52:26PM -0500, Pierre Racine wrote:
> > I better see your point now. Must be the update itself that takes long, not the ST_Value().
> 
> I don't have the original table with me anymore as I re-imported it
> as tiled. I suspect the problem was with && operator and a lack of spatial
> index on one of the two sides. It's pretty quick with the 1x1 version :)

Alright, now I have all my 200k values I'll want to put back into 
the raster. Is there an aggregate form of ST_SetValue ?

--strk; 

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