https://issues.qgis.org/https://issues.qgis.org/favicon.ico2018-10-30T16:03:03ZQGIS Issue TrackingQGIS Application - Bug report #20270: Freeze when opening properties dialog on very large PostGIS layerhttps://issues.qgis.org/issues/20270?journal_id=950212018-10-30T16:03:03ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Operating System</strong> deleted (<del><i>OSX 10.14</i></del>)</li><li><strong>Priority</strong> changed from <i>Normal</i> to <i>High</i></li></ul> QGIS Application - Bug report #20270: Freeze when opening properties dialog on very large PostGIS layerhttps://issues.qgis.org/issues/20270?journal_id=964902018-11-23T11:00:17ZAntal Koszakosza.antal@gmail.com
<ul></ul><p>I can confirm this bug.</p>
<p>In my layer, there are approx. 3.5 million rows. Qgis did not finish in half an hour, but after killing the running query process, the properties dialog box appears instantly.</p>
<p>The same query (SELECT count (*) FROM tablename) with psql was 210 ms, according to the timing option. With ogrinfo ca. 500 ms.</p>
<p>My system is debian buster, with self build qgis, from up to date branch release_3_4.<br />details<br />QGIS verziĆ³ 3.4.1-Madeira<br />QGIS 8f1c51b4a6<br />Qt 5.11.2<br />GDAL/OGR 2.3.2<br />GEOS 3.7.0-CAPI-1.11.0<br />PostgreSQL 11.1 (Debian 11.1-1+b1)<br />PROJ 5.2.0</p> QGIS Application - Bug report #20270: Freeze when opening properties dialog on very large PostGIS layerhttps://issues.qgis.org/issues/20270?journal_id=964932018-11-23T11:35:35ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Affected QGIS version</strong> changed from <i>3.4.0</i> to <i>3.4.1</i></li></ul><p>Very painful regression for all large postgis tables users.</p> QGIS Application - Bug report #20270: Freeze when opening properties dialog on very large PostGIS layerhttps://issues.qgis.org/issues/20270?journal_id=965252018-11-23T21:40:30ZAntal Koszakosza.antal@gmail.com
<ul></ul><p>A workaround? <a class="external" href="https://lists.osgeo.org/pipermail/qgis-user/2018-October/041418.html">https://lists.osgeo.org/pipermail/qgis-user/2018-October/041418.html</a></p> QGIS Application - Bug report #20270: Freeze when opening properties dialog on very large PostGIS layerhttps://issues.qgis.org/issues/20270?journal_id=965492018-11-25T19:33:28ZGeoff Smithgeoff@geoff.me
<ul></ul><p>Thanks for the suggestion Antal, though I'm afraid that workaround doesn't improve things for me, still does the "SELECT *" when I open the layer properties.</p>