Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a problem... I have been successful in uploading the raster in postgis but when I access it through Qgis. it does not open even after several hours.

I have 10GB aerial image raster and everytime i try to open it through QGIS it does not open even after many hours and QGIS crashes...

why is this happening...?? is it really due to the file size..??

Regards, Omer

share|improve this question
How did you load (correctly) the file into postgis? Is it indexed - do request a small area spatially? – Mapperz Aug 27 '13 at 16:48
This is also posted on the qgis-user mailing list... – SaultDon Aug 27 '13 at 21:24
You're loading it and then trying to view the whole extent in QGIS? Yes, it's the file size. You can't view a 10G image without overviews, and your database raster probably doesn't have overviews built. If you're just looking at it, leave it as a file and access it there, it'll be loads faster and even will work. – Paul Ramsey Aug 28 '13 at 17:13
up vote 1 down vote accepted

Raster was loaded properly in Postgis with overviews but qgis plugin "Add a Postgis Raster layer" can't handle this file due to the size (10GB). However, I was successful in adding a subset of that raster whose size was comparatively very small. QGIS displays that raster correctly. I have tried raster having maximum 3GB size. If anyone has succeeded with more than this size, kindly post a comment here

share|improve this answer

Try building a virtual raster and pyramids from the original. Qgis should then only load the visible part into memory.

See for details

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.