You could work around it by loading each overview as a separate layer and specifying visibility rules for each layer.
I don't know if the GDAL driver is working on pyramid usage. -bborie On 09/07/2012 10:50 AM, Brian Fitzgerald wrote: > "The rendering of the raster in QGIS is slow because the GDAL PostGIS > raster driver does not use pyramids in addition to several other > inefficiencies (one query per row) > > Is this something can be worked around or is being worked on? > > > > > On Fri, Sep 7, 2012 at 12:47 PM, Bborie Park <bkp...@ucdavis.edu> wrote: > >> Brian, >> >> You should have raster2pgsql already since you compiled PostGIS from >> source. There is no option in the build process to not compile >> raster2pgsql. >> >> The rendering of the raster in QGIS is slow because the GDAL PostGIS >> raster driver does not use pyramids in addition to several other >> inefficiencies (one query per row). >> >> -bborie >> >> On 09/07/2012 09:09 AM, Brian Fitzgerald wrote: >>> I've finally manged to get the following stack working >>> >>> - Linux Mint 13 Mate >>> - Postgresql 9.1 >>> - GDAL 1.9.1 built from source >>> - GEOS 3.3.5 built from source >>> - Postgis 2.0.1 built from source with GEOS and GDAL above >>> - QGIS nightlies for ubuntu >>> >>> - I imported a digital ortho raster tiff (in SRID 2273) into Postgis >> using >>> the Database -> PostGIS Raster -> Load function >>> - I then loaded this raster into QGIS using the Database -> Postgis >> Raster >>> -> Add function >>> >>> This works 'ok'... the 1mile x 1mile 1ft res image does finally display, >>> but it takes like 2 minutes (presumably because there are no pyramids?) >>> >>> So I wanted to try and load a raster using the raster2pgsql tool... >>> however, I've realized that I don't have it because I built from >> source... >>> so: >>> >>> Is there a place I can download the raster2pgsql tool source and also >> build >>> it from scratch? >>> Is there an alternative? >>> Is the reason the image is drawing sooooo slowly a lack of pyramids? >>> >>> Thanks!!! >>> >>> - Brian >>> >>> >>> >>> >>> _______________________________________________ >>> postgis-users mailing list >>> postgis-users@postgis.refractions.net >>> http://postgis.refractions.net/mailman/listinfo/postgis-users >>> >> >> -- >> Bborie Park >> Programmer >> Center for Vectorborne Diseases >> UC Davis >> 530-752-8380 >> bkp...@ucdavis.edu >> _______________________________________________ >> postgis-users mailing list >> postgis-users@postgis.refractions.net >> http://postgis.refractions.net/mailman/listinfo/postgis-users >> > > > > > > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > -- Bborie Park Programmer Center for Vectorborne Diseases UC Davis 530-752-8380 bkp...@ucdavis.edu _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
