[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