https://issues.qgis.org/https://issues.qgis.org/favicon.ico2016-02-22T13:00:41ZQGIS Issue TrackingQGIS Application - Feature request #14356: Improve postgis topology loading performancehttps://issues.qgis.org/issues/14356?journal_id=684832016-02-22T13:00:41ZSandro Santillistrk@kbt.io
<ul><li><strong>Assignee</strong> changed from <i>Jürgen Fischer</i> to <i>Sandro Santilli</i></li><li><strong>Status</strong> changed from <i>Open</i> to <i>In Progress</i></li></ul><p>Jürgen Fischer suggested to look at 'setUseEstimatedMetadata': <br /><a class="external" href="http://qgis.org/api/classQgsDataSourceURI.html#aa93f799954aee0467b7ed9fa41daecff">http://qgis.org/api/classQgsDataSourceURI.html#aa93f799954aee0467b7ed9fa41daecff</a></p> QGIS Application - Feature request #14356: Improve postgis topology loading performancehttps://issues.qgis.org/issues/14356?journal_id=684842016-02-22T13:18:34ZSandro Santillistrk@kbt.io
<ul><li><strong>Resolution</strong> set to <i>fixed/implemented</i></li><li><strong>Status</strong> changed from <i>In Progress</i> to <i>Closed</i></li></ul><p>Much much better with <a class="changeset" href="https://issues.qgis.org/projects/qgis/repository/revisions/d8a768f0a0b1926ead3b42c0fa9e12d35f8905f0" title="Make geometry typmod available for topology face layer queries Greatly improves performances on ...">d8a768f0a0b1926ead3b42c0fa9e12d35f8905f0</a></p> QGIS Application - Feature request #14356: Improve postgis topology loading performancehttps://issues.qgis.org/issues/14356?journal_id=684852016-02-22T13:27:33ZSandro Santillistrk@kbt.io
<ul></ul><p>Just a note: all the commit does is setting a type-mod based constraint on the geometry column of the query to specify a type and a srid. As the URI already contained both the type and the srid information, I'm wondering if a regression is really hiding here (why should the provider NOT TRUST the uri info?)</p> QGIS Application - Feature request #14356: Improve postgis topology loading performancehttps://issues.qgis.org/issues/14356?journal_id=684862016-02-22T13:31:37ZSandro Santillistrk@kbt.io
<ul></ul><p>Could the problem be related to the deprecation of setWkbType (QGis::WkbType type) ?</p> QGIS Application - Feature request #14356: Improve postgis topology loading performancehttps://issues.qgis.org/issues/14356?journal_id=684912016-02-22T21:42:26ZSandro Santillistrk@kbt.io
<ul></ul><p><a class="changeset" href="https://issues.qgis.org/projects/qgis/repository/revisions/976015a38dedb22c16a84cf8c741d052905f20b9" title="Fix typmod aware query for topology face layers followup d8a768f0a0b1926ead3b42c0fa9e12d35f8905f...">976015a38dedb22c16a84cf8c741d052905f20b9</a> fixes the previous.</p>
<p>While the performances are better, there's still a full primary key column scan.<br />I'll file a separate ticket for that.</p>