[Qgis-developer] PostGIS Rasters

Robert Hewlett rob.hewy at gmail.com
Tue Apr 11 06:29:21 PDT 2017


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

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.


On Mon, Apr 10, 2017 at 10:56 PM, Neumann, Andreas <a.neumann at carto.net>

> 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
> Unsubscribe: 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/c457050c/attachment.html>

More information about the Qgis-developer mailing list