[postgis-users] view raster data and query performance

[Melpati, Muni]

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

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