Is the rasters in same projection (CRS) as the QGIS project ?
Med venlig hilsen / Best regards
Bo Victor Thomsen
Den 13-12-2022 kl. 07:50 skrev Alex German:
I did everything as described in the documentation.
raster2pgsql -I -C -e -Y -F -s 4326 -t 128x128 -l 2,4,8,16,32
"d:\Temp\060 tiff\res\t1.tif" testrastr.t1 | psql.
The download is very slow.
https://youtu.be/LULngZIs4nc
вт, 13 дек. 2022 г. в 09:45, Regina Obe <l...@pcorp.us>:
PostGIS raster sadly doesn’t use the pyramids in the Tifs. Or if
it does no one told me.
You should build raster overviews using the raster2pgsql –l switch.
https://postgis.net/docs/using_raster_dataman.html#RT_Raster_Loader
Doc example is this which builds a level 2 and 4 pyramid
raster2pgsql -I -C -e -Y -F -s 26986 -t 128x128 -l 2,4
bostonaerials2008/*.jpg aerials.boston | psql -U postgres -d gisdb -h localhost
-p 5432
QGIS knows how to use the overviews built that way and should be
much faster to view in QGIS
raster2pgsql -s 4326 -t 256x256 -C -I -F "d:\Temp\060
tiff\res\OCG_t1.tif" OCG_t1 -R| psql.
*From:*postgis-users
[mailto:postgis-users-boun...@lists.osgeo.org] *On Behalf Of *Alex
German
*Sent:* Monday, December 12, 2022 11:34 PM
*To:* PostGIS Users Discussion <postgis-users@lists.osgeo.org>
*Subject:* [postgis-users] Qgis + PostGis. Low operating speed.
Hello everyone!
I have a GeoTIFF.
I built the pyramids in an external file using GDAL
"gdaladdo d:\Temp\060 tiff\res\t1.tif -r lanczos -ro 2 4 8 16 32
64 128 256 512.
Uploaded to PostGIS using
raster2pgsql -s 4326 -t 256x256 -C -I -F "d:\Temp\060
tiff\res\OCG_t1.tif" OCG_t1 -R| psql.
The number of files is more than 1000.
When trying to load tables in QGis, the loading is very slow.
At the same time, downloading to QGis from files is fast.
Question. What is not configured correctly and how to speed up the
download to Qgis from PostGIS?
--
Alex German
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
--
Алексей Герман
8-905-86-00-416
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
