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 <[email protected]> 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 <[email protected]> > 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 <[email protected]> >> 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 <[email protected]> >>> 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 >>>> [email protected] >>>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer >>>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer >>>> >>>> >>>> >>>> >>> >>> >>> >> >> >> _______________________________________________ >> Qgis-developer mailing list >> [email protected] >> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer >> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer >> > >
_______________________________________________ Qgis-developer mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
