[Qgis-developer] PostGIS Rasters

[Pieter du Plooy]

Hi Robert

Just a little of topic question.  Your centos install for Postgres etc, is
that only using Postgres Yum repo?

Your QGIS frontend, is that also Centos?

Pieter

On Tue, Apr 11, 2017 at 6:27 PM, Robert Hewlett <rob.hewy at gmail.com> wrote:

> Hi,
>
> Quick test results. Attached are the statistics reports exported from pg
> admin 3.
>
> Loaded an ortho table (PostGIS raster) called bcit_otho that has several
> overview tables.
>
> After panning and zooming the o_2_bcit_ortho seems to be 'hit' a few times.
>
> On Tue, Apr 11, 2017 at 6:47 AM, Neumann, Andreas <a.neumann at carto.net>
> wrote:
>
>> 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
>>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>>>
>>>
>>>
>>>
>>
>>
>>
>
>
> _______________________________________________
> 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/78ac0e15/attachment.html>