[Qgis-developer] PostGIS Rasters

[Robert Hewlett]

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
>>
>>
>>
>>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20170411/9f5049fe/attachment-0003.html>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20170411/9f5049fe/attachment-0004.html>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20170411/9f5049fe/attachment-0005.html>