[postgis-users] Why so terribly slow?

Sandro Santilli strk at keybit.net
Fri Feb 10 09:31:34 PST 2012


On Fri, Feb 10, 2012 at 09:13:59AM -0800, DavidRA wrote:
> Several test later, I'm sure that ST_MapAlgebraExpr() suits me perfectly.
> Besides it's very easy to use.
> 
> It's slower than using the equivalent function on a GIS tool like GRASS but
> I think that could be expected, isn't it? Though I'm curious about the
> reasons...

With great Power come great Slowness! :)

Seriously, the PostGIS version lets you use any kind of query, starting
up the PostGIS evaluator, which isn't really made to execute thousands
of statements at once.

--strk; 

  ,------o-. 
  |   __/  |    Delivering high quality PostGIS 2.0 !
  |  / 2.0 |    http://strk.keybit.net
  `-o------'




More information about the postgis-users mailing list