[postgis-users] Qgis + PostGis. Low operating speed.

[Alex German]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20221213/2ae233ac/attachment.htm>