[Qgis-developer] PostGIS Rasters

Neumann, Andreas a.neumann at carto.net
Tue Apr 11 06:47:02 PDT 2017


Hi Rob, 

Thanks for testing. Good to know that pyramids now work fine with
postgis raster. It was a while back since I last tested. 

If you can log the SQL queries on the server by increasing the logging
level, than it you can prove which tables QGIS is querying. 

Andreas 

On 2017-04-11 15:29, Robert Hewlett wrote:

> Hi, 
> 
> I am using 2.18.5. and the performance seems okay to good.  
> 
> The ortho data in the DB are tiled and have overviews built. 
> 
> When working with the data within QGIS it seems that the overviews are 'in play'. 
> 
> I will see if I can write some SQL to prove one way or the other.  
> 
> The test vm on the back-end: CentOS 7, Postgres 9.6 with PostGIS 2.3.2 (all repo based). 
> 
> The front-end will move to 2.18.6 later today. 
> 
> Rob 
> 
> On Mon, Apr 10, 2017 at 10:56 PM, Neumann, Andreas <a.neumann at carto.net> wrote:
> 
> Hi, 
> 
> If there will be a new Postgis raster provider for QGIS, it should also support the pyramid tables (separate tables) - which as far as I know - is not yet supported. If you add a layer from DB-manager you load a fixed resolution and the other pyramid tables won't be used. Thats one of the reasons, rasters in Postgis display quite slow in QGIS. 
> 
> Andreas
> 
> On 2017-04-11 04:16, Robert Hewlett wrote: 
> 
> Hi, 
> 
> Are there plans to build a plugin for PostGIS rasters similar to the vector plugin. I know how to add the rasters from the DB manager but the experience/workflow is much different and the connections go 'stale'. 
> 
> I am willing to help code it. 
> 
> Regards, 
> 
> Rob 
> _______________________________________________
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer [1]
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer [1]

  

Links:
------
[1] https://lists.osgeo.org/mailman/listinfo/qgis-developer
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20170411/f8b34301/attachment.html>


More information about the Qgis-developer mailing list