[Qgis-developer] Trouble with PostGis plugin

[walter.nordmann]

Hi,
Running Qgis 2.4 on Ubuntu 14.4

i'm using (or better try to use) the PostGis-Plugin on a really big database
(full osm Planet with Tables countaining 5-100 millions of datarecords)

First: when adding a PostGis Layer Filter, the plugin is doing a query to
get the geometry of the Objects and this Query runs extremly long (30-60
Minutes). And this happens everytime i change a little bit (even only the
color of something.)

Is there a way, to tune that? All usual indexes of this OSM-Tables exist.

Second: Is there a way to monitor (see) the real Queries the Plugin is
sending to the database-server?

now, i'm running whireshark (network monitor) to fetch them! That's awfull.

May be there is a  debugging options which i don't know about. If i have to
i can install 2.5-dev too.

Regards
walter

ps: Yes, may be i should ask that on the user-list. I tried it some months
ago and did not get any good answer.




--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Trouble-with-PostGis-plugin-tp5166669.html
Sent from the Quantum GIS - Developer mailing list archive at Nabble.com.