[postgis-users] view raster data and query performance

Bborie Park bkpark at ucdavis.edu
Mon Jul 30 14:04:03 PDT 2012


For QGIS, you need to use the PostGIS Raster plugin, not the PostGIS plugin.

-bborie

On 07/30/2012 01:26 PM, Melpati, Muni wrote:
> I cannot answer for that. If anyone had this problem and fixed it, I would like to know how they have done it.
> 
> Moreover, When I tries to store raster data outside the database, I could not even add the layer from QGIS. When I tried to add the layer using postgis plugin, I find raster layer related columns (pixel type, is extrernal file, pixel size x, pixel size y in the "load potgis raster layer " interface, has values none. I must have done something wrong. When I add this raster layer, QGIS crashes.
> 
> Here is the syntax I have used:
> 
> raster2pgsql -I -R -e -Y -F -s 26986 -t 128x128  c:\PostGIS\raster\dowell.jpg public.raster | psql -U postgres -d gisdb -h localhost -p 5432
> 
> 
> 
> Anything wrong with it. Thanks.
> 
> 
> 
> 
> 
> 
> 
> Date: Mon, 30 Jul 2012 12:16:52 +0200
> 
> From: Paolo Cavallini <cavallini at faunalia.it<mailto:cavallini at faunalia.it>>
> 
> Subject: Re: [postgis-users] view raster data and query performance
> 
> To: postgis-users at postgis.refractions.net<mailto:postgis-users at postgis.refractions.net>
> 
> Message-ID: <50165F14.6060909 at faunalia.it<mailto:50165F14.6060909 at faunalia.it>>
> 
> Content-Type: text/plain; charset="iso-8859-1"
> 
> 
> 
> Il 27/07/2012 23:22, Melpati, Muni ha scritto:
> 
>>
> 
>> I have also changed postgresql.config file to improve the performance
> 
>> with no noticeble difference. Can anyone faced this problem or have
> 
>> any suggestion to improve the performance? Thanks in advance.
> 
>>
> 
>>
> 
> Agreed, it is so slow to be barely usable in real world. I suppose this is due to the GDAL provider, right?
> 
> All the best.
> 
> 
> 
> --
> 
> Paolo Cavallini - Faunalia
> 
> 
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 

-- 
Bborie Park
Programmer
Center for Vectorborne Diseases
UC Davis
530-752-8380
bkpark at ucdavis.edu



More information about the postgis-users mailing list