Skip to content

Updated Canvas gives inconsistent Min / Max values and colour ranges for a local raster vs. the same raster in postgres #64917

Description

@kewgis

What is the bug or the crash?

When I view a raster as a local .tif file vs. the same raster loaded into postgres with the same Singleband pseudocolor rendering and Statistics extent set to "Updated Canvas", I get very different results. Both visually with the range of the colour band applied, and numerically with the min / max values.

Recording.2026-02-12.193056.mp4

Steps to reproduce the issue

  1. Download this clipped EMODnet Bathymetry raster:
    D4_2024_clipped.tif

  2. Load the raster into a postgres database (with PostGIS raster installed)
    raster2pgsql -t auto -q -c -F -I -C -M -Y "C:\GIS\Data\EMODnet\D4_2024_clipped.tif" test.bathy | psql -U postgres -d gisdata -h localhost -p 5432

  3. Repeat steps as in above video

Versions

QGIS version3.44.7-Solothurn
QGIS code revisionea262bc5ed8
 
Libraries
Qt version5.15.13
Python version3.12.12
GDAL version3.12.1 — Chicoutimi
PROJ version9.7.1
EPSG Registry database versionv12.029 (2025-10-03)
GEOS version3.14.1-CAPI-1.20.5
SQLite version3.50.4
PDAL version2.9.0
PostgreSQL client version17.3
SpatiaLite version5.1.0
QWT version6.3.0
QScintilla2 version2.14.1
OS versionWindows 11 Version 2009
 
Active Python plugins
db_manager0.1.20
grassprovider2.12.99
MetaSearch0.3.6
processing2.12.99

Supported QGIS version

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

New profile

Additional context

No response

Metadata

Metadata

Assignees

Labels

BugEither a bug report, or a bug fix. Let's hope for the latter!RastersRelated to general raster layer handling (not specific data formats)

Type

No type
No fields configured for issues without a type.

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions