[Qgis-user] OSM and postgres speed

[Thomas Endres]

Hi Everyone,
Running QGIS 2.12.0, Postgres 9.4.4, and PostGIS 2.1.7 on Ubuntu 14.04 with
16 gig RAM.

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.
Progress bar runs for a very long time with no apparent visible changes.
Indexes and configuration on the db side looks good.
Wondering how to diagnose extremely slow rendering times from a local
postgres instance? Do I need to build from scratch to enable logs?
While trying to monitor the server I noticed the following:
- a few processes running SELECT st_estimatedextent....
- a few processes running FETCH FORWARD 2000 FROM...

Thanks in advance for any pointers.
-tom
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20151103/f37dc22e/attachment.html>