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 <cavall...@faunalia.it<mailto:cavall...@faunalia.it>> Subject: Re: [postgis-users] view raster data and query performance To: postgis-users@postgis.refractions.net<mailto:postgis-users@postgis.refractions.net> Message-ID: <50165f14.6060...@faunalia.it<mailto:50165f14.6060...@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@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users