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

Jakob Lanstorp jakla at mst.dk
Tue Dec 13 00:18:32 PST 2022

There are issues and memory leaks with the PG raster in QGIS.

See https://github.com/qgis/QGIS/issues/47815


Den 13-12-2022 kl. 07:50 skrev 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


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



Alex German

-------------- next part --------------

An HTML attachment was scrubbed...

URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20221213/2ae233ac/attachment.htm>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20221213/a6fc9e30/attachment.htm>

More information about the postgis-users mailing list