<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)">QGis does not pick up overviews. </span><div><span style="color:rgb(0,0,0);font-size:13px;white-space:pre-wrap;background-color:rgba(7,28,71,0.05)">Separately, overviews are loaded very quickly. </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.e. if I load o_16_t6 in qgis, then the download speed is excellent. </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)">In the properties of the table, there are overviews.</span><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">вт, 13 дек. 2022 г. в 12:29, Alex German <<a href="mailto:gr1047@gmail.com">gr1047@gmail.com</a>>:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><img src="cid:ii_lblwitmc0" alt="image.png" width="562" height="135"><br><div>SRID in postgis 4326</div><div><img src="cid:ii_lblwjswx1" alt="image.png" width="194" height="159"><br></div><div>SRID in QGis 4326</div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">вт, 13 дек. 2022 г. в 12:05, Bo Victor Thomsen <<a href="mailto:bo.victor.thomsen@gmail.com" target="_blank">bo.victor.thomsen@gmail.com</a>>:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
<p>Is the rasters in same projection (CRS) as the QGIS project ? <br>
</p>
<pre cols="72">Med venlig hilsen / Best regards
Bo Victor Thomsen</pre>
<div>Den 13-12-2022 kl. 07:50 skrev Alex
German:<br>
</div>
<blockquote type="cite">
<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)">I did everything as described in the documentation. </span>
<div><span style="color:rgb(0,0,0);font-size:13px;white-space:pre-wrap;background-color:rgba(7,28,71,0.05)">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. </span>
<div><span style="color:rgb(0,0,0);font-size:13px;white-space:pre-wrap;background-color:rgba(7,28,71,0.05)">The download is very slow.</span><br>
</div>
</div>
<div><a href="https://youtu.be/LULngZIs4nc" target="_blank">https://youtu.be/LULngZIs4nc</a><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>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">вт, 13 дек. 2022 г. в 09:45,
Regina Obe <<a href="mailto:lr@pcorp.us" target="_blank">lr@pcorp.us</a>>:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
<div lang="EN-US">
<div>
<p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">PostGIS
raster sadly doesn’t use the pyramids in the Tifs.
Or if it does no one told me.</span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">You
should build raster overviews using the raster2pgsql
–l switch. </span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><a href="https://postgis.net/docs/using_raster_dataman.html#RT_Raster_Loader" target="_blank">https://postgis.net/docs/using_raster_dataman.html#RT_Raster_Loader</a></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span></p>
<pre><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Doc example is this which builds a level 2 and 4 pyramid</span></pre>
<pre>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</pre>
<p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">QGIS
knows how to use the overviews built that way and
should be much faster to view in QGIS</span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span></p>
<p class="MsoNormal"><span style="font-size:10pt;color:black">raster2pgsql -s
4326 -t 256x256 -C -I -F "d:\Temp\060
tiff\res\OCG_t1.tif" OCG_t1 -R| psql. </span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span></p>
<div style="border-top:none;border-right:none;border-bottom:none;border-left:1.5pt solid blue;padding:0in 0in 0in 4pt">
<div>
<div style="border-right:none;border-bottom:none;border-left:none;border-top:1pt solid rgb(225,225,225);padding:3pt 0in 0in">
<p class="MsoNormal"><b><span style="font-size:11pt;font-family:Calibri,sans-serif">From:</span></b><span style="font-size:11pt;font-family:Calibri,sans-serif"> postgis-users
[mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a>]
<b>On Behalf Of </b>Alex German<br>
<b>Sent:</b> Monday, December 12, 2022 11:34
PM<br>
<b>To:</b> PostGIS Users Discussion <<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a>><br>
<b>Subject:</b> [postgis-users] Qgis +
PostGis. Low operating speed.</span></p>
</div>
</div>
<p class="MsoNormal"> </p>
<div>
<p class="MsoNormal"><span style="font-size:10pt;color:black">Hello
everyone!</span></p>
<div>
<p class="MsoNormal"><span style="font-size:10pt;color:black">I have a
GeoTIFF. </span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10pt;color:black">I built the
pyramids in an external file using GDAL </span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10pt;color:black">"gdaladdo
d:\Temp\060 tiff\res\t1.tif -r lanczos -ro 2 4
8 16 32 64 128 256 512. </span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10pt;color:black">Uploaded to
PostGIS using </span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10pt;color:black">raster2pgsql
-s 4326 -t 256x256 -C -I -F "d:\Temp\060
tiff\res\OCG_t1.tif" OCG_t1 -R| psql. </span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10pt;color:black">The number
of files is more than 1000. </span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10pt;color:black">When trying
to load tables in QGis, the loading is very
slow. </span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10pt;color:black">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">
</p>
<div>
<p class="MsoNormal"> </p>
</div>
<p class="MsoNormal">-- </p>
<div>
<p class="MsoNormal">Alex German</p>
<div>
<p class="MsoNormal"> </p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><br>
</div>
</blockquote>
</div>
<br clear="all">
<div><br>
</div>
-- <br>
<div dir="ltr">Алексей Герман
<div>8-905-86-00-416</div>
</div>
<br>
<fieldset></fieldset>
<pre>_______________________________________________
postgis-users mailing list
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
</div>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><br>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr">Алексей Герман<div>8-905-86-00-416</div></div>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" class="gmail_signature">Алексей Герман<div>8-905-86-00-416</div></div>