[postgis-devel] ST_Value performance

[Sandro Santilli]

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 :)

--strk;

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