[postgis-devel] To PL/pgSQL or not to PL/pgSQL

[George Silva]

Hello Pierre,

I'm up for a plpgsql implementation for now. I've written a few functions
for wkt raster, but as you noticed, I stumbled upon some problems for the
more complex ones.

I've implemented also: plus, minus, and other math operations for rasters.
They all work fine.

When I get home I'll email it to the list and you can use them as you seem
fit.

Cheers,

George

On Thu, Aug 19, 2010 at 5:10 PM, Pierre Racine
<Pierre.Racine at sbf.ulaval.ca>wrote:

> Hi,
>
> Are functions written in C REALLY faster than functions written in
> PL/pgSQL? Why?
>
> Is there any rule saying what king of function should be better implemented
> in C and what kind should be better (of OK) in PL/pgSQL?
>
> Do you guys prefer to publish a slower PL/pgSQL function NOW (warning that
> it might be implemented in C later with the same signature) or wait months
> that the C equivalent is implemented?
>
> I understand that most of the PostGIS functionality is in GEOS but we don't
> have a GEOS equivalent for WKT Raster (we have GDAL but it's very limited in
> terms of analysis functionality) and I feel that everything would go much
> faster implementing many things in PL/pgSQL. For example right now I'm
> implementing a nice ST_MapAlgebra function in PL/pgSQL. I have no idea if it
> would be really much faster in C. I love PL/pgSQL...
>
> Thanks for your advices,
>
> Pierre
>
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-devel
>



-- 
George R. C. Silva

Desenvolvimento em GIS
http://blog.geoprocessamento.net
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20100819/ebd1e4a6/attachment.html>