[postgis-users] Why so terribly slow?

Paul Ramsey pramsey at opengeo.org
Fri Feb 10 10:29:10 PST 2012


Perhaps SomeDay an ST_FastMapAlgebra, with a limited grammar and
native calculation speed, but without the power of access to every
single capability of SQL.

P.

On Fri, Feb 10, 2012 at 9:31 AM, Sandro Santilli <strk at keybit.net> wrote:
> 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------'
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users



More information about the postgis-users mailing list