Is there any work around to mitigate the amount of time QGIS takes when loading projects that have large tables from postgis layers . I have tried to turn off this large layers so they are not in use , save , close project and then reopen project hoping that the turned off layers would not load on project start again. But nothing it seems that it will always load the tables in memory even though they are turned off. Any suggestion ??? using 2.8.2 - Wien on windows

  • It surprises me a bit that the layers have that much influence. I have layers with millions of geometries and my projects behave fine. It is different though when you want to add layers from the dbase manager for tables that have no GeometryType set. Could that be what you mean? Or could it be that there are some old layer references in your QML file to stores that don't exist anymore? – tilt Feb 11 '16 at 19:37
  • As far as I understand when you start a project that has layers with no reference qgis warns you and will not load them, the layers do have geometry types set , It indicates on the bottom bar loading and name of the layer loading plus the he progress bar keeps stainless for wile on every layer that is loading . not sure what your millions are but I'm talking about layers of more than 50 million objects that I display at certain zoom levels only. – Jorge Vidinha Feb 11 '16 at 22:51
  • Could you give us a step by step explanation of what you do and notice? It makes it easier to reproduce. Another thing: can you confirm that pressing ' escape' stops the loading process? Postgis layers that are off should not load data and even when they are on only the geometries that are within the bounding box will be loaded (every time you pan or zoom). I assume the tables are indexed on geometries? – tilt Feb 12 '16 at 8:18

In the Postgis connection settings, selecting the "Don't resolve type of unrestricted columns (GEOMETRY)" checkbox usually helps.

enter image description here

|improve this answer|||||
  • 1
    Does ticking this option helps for loading layers that are in the layer trees or only for displaying all available layers when connecting to a db? If it is the second case, then it does not really help when opening a project with heavy postgis layers. – juminet Jan 16 '19 at 16:25

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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