Re: [Qgis-developer] Trouble with PostGis plugin
Hi Walter When you connect to the PostGis database make sure that you have selected the Use estimated metadata option - this optimises the connection for large datasets - see attached screenshot. This should greatly improve the connection times for postigs. (If you are already doing this then may need to look further!) Cheers Chris From: walter.nordmann [walter.nordm...@web.de] Sent: 10 October 2014 02:29 To: qgis-developer@lists.osgeo.org Subject: Re: [Qgis-developer] Trouble with PostGis plugin sorry, no special plugin; just that build in PostGis tool. mainly i need to the the queries going to the server in order to optimize some indexes. even adding EXPLAIn to the Query whould help a lot. regards walter -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Trouble-with-PostGis-plugin-tp519p5166687.html Sent from the Quantum GIS - Developer mailing list archive at Nabble.com. This message contains information, which may be in confidence and may be subject to legal privilege. If you are not the intended recipient, you must not peruse, use, disseminate, distribute or copy this message. If you have received this message in error, please notify us immediately (Phone 0800 665 463 or i...@linz.govt.nz) and destroy the original message. LINZ accepts no responsibility for changes to this email, or for any attachments, after its transmission from LINZ. Thank You. ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [Qgis-developer] Trouble with PostGis plugin
Chris Crook wrote Hi Walter When you connect to the PostGis database make sure that you have selected the Use estimated metadata option - this optimises the connection for large datasets - see attached screenshot. This should greatly improve the connection times for postigs. (If you are already doing this then may need to look further!) Use estimated metadata is true and i see (in wireshark!) qgis is only fetching 100 samples to get the geometry. But even that needs a very long time. I think, Postgis is doing a sequential search but i'm no shure about that. But why does Qgis check the geometry? it is allready known and should not be necessary. This part of Qgis is for me like a Black Box: select your data and wait. No loggin, no infos, nothing. Just wait. That is very frustrating in the developement-phase of a map. Killed the Qgis-Process dozend times a day, loaded my last save and started again. :( Regards walter -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Trouble-with-PostGis-plugin-tp519p5166851.html Sent from the Quantum GIS - Developer mailing list archive at Nabble.com. ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [Qgis-developer] Trouble with PostGis plugin
Sandro Santilli-2 wrote Can you send the whole query ? I think there's a class of such issues with big tables that need be addressed (and secured with some automated testcase). I did it again and - performance is ok - no idea what is going on there. :( This part of Qgis is for me like a Black Box: select your data and wait. No loggin, no infos, nothing. Just wait. You can open some of the box by connecting to the database and looking at the pg_stat_activity table. will try it this night with another table. But: it would be much much easier if Qgis would do the Job: log all queries sent to to the server instead of using external tools to fetch that infos. Using pgadmin3, postgresql server logs, pg_stat_activity or even wireshark, which is for catching network traffic, is a little bit strange. ... if something has to be fixed it has a chance to be in time for version 2.6 (due in 2 weeks). Thanks walter -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Trouble-with-PostGis-plugin-tp519p5166944.html Sent from the Quantum GIS - Developer mailing list archive at Nabble.com. ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
[Qgis-developer] Trouble with PostGis plugin
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-tp519.html Sent from the Quantum GIS - Developer mailing list archive at Nabble.com. ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [Qgis-developer] Trouble with PostGis plugin
Il 09/10/2014 13:59, walter.nordmann ha scritto: 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 Hi Walter, which plugin do you mean? All the best. -- Paolo Cavallini - www.faunalia.eu Corsi QGIS e PostGIS: http://www.faunalia.eu/training.html ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [Qgis-developer] Trouble with PostGis plugin
sorry, no special plugin; just that build in PostGis tool. mainly i need to the the queries going to the server in order to optimize some indexes. even adding EXPLAIn to the Query whould help a lot. regards walter -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Trouble-with-PostGis-plugin-tp519p5166687.html Sent from the Quantum GIS - Developer mailing list archive at Nabble.com. ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer