<div dir="ltr"><span style="color:rgb(0,0,0);font-size:13px;white-space:pre-wrap;background-color:rgba(7,28,71,0.05)">Hello everyone!</span><div><span style="color:rgb(0,0,0);font-size:13px;white-space:pre-wrap;background-color:rgba(7,28,71,0.05)">I have a GeoTIFF. </span></div><div><span style="color:rgb(0,0,0);font-size:13px;white-space:pre-wrap;background-color:rgba(7,28,71,0.05)">I built the pyramids in an external file using GDAL </span></div><div><span style="color:rgb(0,0,0);font-size:13px;white-space:pre-wrap;background-color:rgba(7,28,71,0.05)">"gdaladdo d:\Temp\060 tiff\res\t1.tif -r lanczos -ro 2 4 8 16 32 64 128 256 512. </span></div><div><span style="color:rgb(0,0,0);font-size:13px;white-space:pre-wrap;background-color:rgba(7,28,71,0.05)">Uploaded to PostGIS using </span></div><div><span style="color:rgb(0,0,0);font-size:13px;white-space:pre-wrap;background-color:rgba(7,28,71,0.05)">raster2pgsql -s 4326 -t 256x256 -C -I -F "d:\Temp\060 tiff\res\OCG_t1.tif" OCG_t1 -R| psql. </span></div><div><span style="background-color:rgba(7,28,71,0.05);color:rgb(0,0,0);font-size:13px;white-space:pre-wrap">The number of files is more than 1000</span><span style="color:rgb(0,0,0);font-size:13px;white-space:pre-wrap;background-color:rgba(7,28,71,0.05)">. </span></div><div><span style="color:rgb(0,0,0);font-size:13px;white-space:pre-wrap;background-color:rgba(7,28,71,0.05)">When trying to load tables in QGis, the loading is very slow. </span></div><div><span style="color:rgb(0,0,0);font-size:13px;white-space:pre-wrap;background-color:rgba(7,28,71,0.05)">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?</span><br clear="all"><div><br></div>-- <br><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature">Alex German<br><div><br></div></div></div></div>