[Qgis-developer] PostGIS Rasters

[Robert Hewlett]

Hi,

Back end-repo is from here:
https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-centos96-9.6-3.noarch.rpm

The front end is windows:
QGIS-OSGeo4W-2.18.6-1-Setup-x86_64.exe

Output from ver is:
Microsoft Windows [Version 6.1.7601]



On Tue, Apr 11, 2017 at 9:59 AM, Pieter du Plooy <pjduplooy at zpanelcp.com>
wrote:

> 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/ec3af86b/attachment-0001.html>