[postgis-users] raster2pgsql build from source...

[Bborie Park]

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 <bkpark at 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 at postgis.refractions.net
>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>
>>
>> --
>> Bborie Park
>> Programmer
>> Center for Vectorborne Diseases
>> UC Davis
>> 530-752-8380
>> bkpark at ucdavis.edu
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
> 
> 
> 
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 

-- 
Bborie Park
Programmer
Center for Vectorborne Diseases
UC Davis
530-752-8380
bkpark at ucdavis.edu