GeoPackage raster memory consumption

[arturred]

What is the bug or the crash?

Hi

With the latest QGIS opening any GeoPackage raster dataset and navigating the map (many zoom operations) consumes a lot of memory that is increasing a lot eating the whole RAM. This happens on any dataset I have (from the web) and the bigger the map is, the bigger the memory leaks occur taking even 64GB of my PC RAM.

Steps to reproduce the issue

Any bigger GeoPackage raster dataset to observe after memory consumption. I start QGIS with 200MB usage and open a small dataset increasing RAM to 300MB, but after zooming the RAM consumption speeds up to 1 GB and grows. Unfortunately, my raster has a resolution 4000000x2000000. So the RAM consumption increases multi times faster.

Versions

Windows 11 QGIS 3.26.3

Supported QGIS version

• [X] I'm running a supported QGIS version according to the roadmap.

New profile

• [X] I tried with a new QGIS profile

Additional context

No response

[arturred]

Here is a cross-link to GDAL issue .

[agiudiceandrea]

@arturred, could you please provide a sample GPKG with a raster layer the issue occur with?

[arturred]

You can use any sample that you find. The higher resolution, the higher the memory consumption after each zoom. Here is a sample dataset with many vectors and one raster layer that you can test : dataset