<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Hi Tom,<br>
<br>
Several things come to mind:<br>
<br>
* all installed on the same machine? How many cores? 64bit?<br>
* are you trying to route across your network or just draw the
features?<br>
* if you are routing you can try using a bounding box on your query
to limit the number of features returned.<br>
* have you run a full vacuum analyse on your Postgres tables to
update statistics? How many features in your tables?<br>
* try resetting your PostGIS connection in QGIS to not use the
estimate extent.<br>
* spatial and attribute indexes on relevant fields in the table?<br>
* in QGIS you can set, under Settings > Options > Rendering,
to render layers in parallel and also set the number of cores to
use.<br>
* can you set some scale dependent rendering on your layer so that
it only draws some features at small scales and then more detail as
you zoom in?<br>
<br>
Hope that helps a bit<br>
<br>
Cheers<br>
<br>
Ross<br>
<br>
<div class="moz-cite-prefix">On 03/11/15 19:24, Thomas Endres wrote:<br>
</div>
<blockquote
cite="mid:CABnS6Y2c0rXLz-6AEfnBvPfkjTkabDigtwrB_T-E2NKXC6OPfw@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>Hi Everyone,</div>
<div>Running QGIS 2.12.0, Postgres 9.4.4, and PostGIS 2.1.7 on
Ubuntu 14.04 with 16 gig RAM.</div>
<div><br>
</div>
<div>With North America OSM data loaded into postgres via
osm2pgsql I am having some extremely long project load times,
even with only a single simple layer enabled.</div>
<div>Progress bar runs for a very long time with no apparent
visible changes.</div>
<div>Indexes and configuration on the db side looks good.</div>
<div>Wondering how to diagnose extremely slow rendering times
from a local postgres instance? Do I need to build from
scratch to enable logs?</div>
<div>While trying to monitor the server I noticed the following:</div>
<div>- a few processes running SELECT st_estimatedextent....</div>
<div>- a few processes running FETCH FORWARD 2000 FROM...</div>
<div><br>
</div>
<div>Thanks in advance for any pointers.</div>
<div>-tom</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Qgis-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre>
</blockquote>
<br>
</body>
</html>