<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /></head><body style='font-size: 10pt; font-family: Verdana,Geneva,sans-serif'>
<p>Hi,</p>
<p>I think your question is related to this issue [1].</p>
<p>It is about QGIS Server but the issue is the same.</p>
<p>QGIS needs a way to declare the extent of a layer to avoid a query that gets (<span>st_extent</span>) or guesses (<span>st_estimated_extent</span>) the extent.</p>
<p> </p>
<p>[1] : http://hub.qgis.org/issues/14364</p>
<p>Le 2016-11-15 08:11, Sandro Santilli a écrit :</p>
<blockquote type="cite" style="padding: 0 0.4em; border-left: #1010ff 2px solid; margin: 0"><!-- html ignored --><!-- head ignored --><!-- meta ignored -->
<div class="pre" style="margin: 0; padding: 0; font-family: monospace">On Mon, Nov 14, 2016 at 04:43:31PM -0800, Chris Nicholas wrote:<br /> <br />
<blockquote type="cite" style="padding: 0 0.4em; border-left: #1010ff 2px solid; margin: 0">I have noticed for a long time, that despite checking the "use<br /> estimated metadata" box when adding PostGIS layers, QGIS seems to<br /> issue 2 full-table scan queries.</blockquote>
<br /> Could you check if an issue mentioning this problem exists already<br /> on hub.qgis.org and add one if not already present ?<br /> <br /> I've had the same impression and it is possible this was a regression.<br /> It'd be great to have an automated test guarding against full table<br /> scans with PostGIS, to secure the feature once for all..<br /> <br /> --strk;<br /> <br /> () Free GIS & Flash consultant/developer<br /> /\ <a href="https://strk.kbt.io/services.html">https://strk.kbt.io/services.html</a><br /> _______________________________________________<br /> Qgis-developer mailing list<br /> <a href="mailto:Qgis-developer@lists.osgeo.org">Qgis-developer@lists.osgeo.org</a><br /> List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-developer">http://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br /> Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-developer">http://lists.osgeo.org/mailman/listinfo/qgis-developer</a></div>
</blockquote>
</body></html>