For ST_Union you can test my temporary solution: http://geospatialelucubrations.blogspot.ca/2012/07/a-slow-yet-1000x-faster-alternative-to.html
Pierre > -----Original Message----- > From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users- > boun...@postgis.refractions.net] On Behalf Of Jakub Hettler > Sent: Thursday, August 23, 2012 4:12 PM > To: PostGIS Users Discussion > Subject: Re: [postgis-users] Advantages and disadvantages of storing raster in > PostGIS raster > > That was one of my questions, how to make analasys on tiled rasters? Is that > possible or not, I tried to make ST_Union on 200 tiles and I stopped it after > a few > minutes :) > > I am testing raster automatic publication of OGC services through PostGIS > raster > and image mosaic JDBC plugin and Java a I am quiet satisfied, but I have only > small rasters (max 30 Mb), I expected that it will be really slow (reading > raster > from database, merging together and visualize them), but I am quite surprised. > > But I expect that the same rasters will be faster from file system. > > > Thanks > > Jakub > > > 2012/8/23 Bborie Park <bkp...@ucdavis.edu> > > > For my work, PostGIS raster provides a standardized method to store, > manage and query various datasets, specifically longitudinal climate > data and DEM for California. This permits my end-users (researchers > and > various decision support software) to use the SQL knowledge they > already > know to get the data that they're looking for without needing additional > software (ENVI, ERDAS Imagine, ArcGIS). > > The biggest limitation to PostGIS raster in 2.0 (and trunk) is that > there isn't advanced map algebra support (needed for fast unioning and > model output). I hope to start working developing that support in the > next week or two... as I need it for my work. > > -bborie > > > On 08/23/2012 11:34 AM, Jakub Hettler wrote: > > Hi, > > just a simple question, I try to find some work on this issue, but > nothing > > found. > > > > Could somebody provide some information? > > > > Thanks a lot > > > > Jakub > > > > > > > > > _______________________________________________ > > postgis-users mailing list > > postgis-users@postgis.refractions.net > > http://postgis.refractions.net/mailman/listinfo/postgis-users > > > > -- > Bborie Park > Programmer > Center for Vectorborne Diseases > UC Davis > 530-752-8380 > bkp...@ucdavis.edu > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > > _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users