[postgis-users] Favorite distribution for OS X?

[Regina Obe]

I haven't tried plv8 recently with mapalgebra, but the tests I did a while back showed about a 2-3 fold speed improvement over plpgsql and sql.

 

http://www.postgresonline.com/journal/archives/326-Writing-PostGIS-raster-Map-Algebra-Callback-Functions-in-PLV8.html

 

 

Would be interested to see if that is still true today.  I suspect it is as I think the PLV8 engine performs much faster than plgsql and sql for math and string manipulation.

 

 

 

From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of Jerry Sievert
Sent: Saturday, November 10, 2018 8:35 PM
To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
Subject: Re: [postgis-users] Favorite distribution for OS X?

 

Hi John,





I am a Mac user and have been a happy consumer of Kyngchaos PostgreSQL and PostGIS builds for many years.  However, there are a couple of extensions I’m interested in trying that Mr. Kyngesburye doesn’t supply, including PLV8 (I want to see if PLV8 will speed up some raster MapAlgebra problems).  

 

This isn’t quite the right making list for plv8, but there is no official distribution for plv8 for macOS, but https://postgresapp.com (no affiliation) distributes Postgres with both postgis and plv8 extensions.  I can’t promise it will speed anything up, but I’d be interested to hear of your results.

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20181110/51ce053a/attachment.html>