[Qgis-developer] Trouble with PostGis

[Vincent Picavet]

Hi Walter,

Note that if you want to troubleshoot PostGIS problems, you should look at the 
postgres side, not the QGIS one. It would have taken 10 minutes to get the 
problem here.

So :
* configure PostgreSQL server to output logs for every query
* rerun these queries with EXPLAIN in pgadmin / psql
* Use something like pgBadger to analyze your logs and find the bad queries

There are a lot of other PostgreSQL-related tools which can be useful for 
auditing, fine-tuning, troubleshooting PostgreSQL, but it is a bit off-scope for 
this list.

Vincent

Le mardi 4 novembre 2014 22:38:04, walter.nordmann a écrit :
> may be i got it. after purging and recreating idx_planet_boundary and
> idx_planet_admin_level the cursor-query is using those indices and
> performance is on.
> 
> yes, i'm running vacuum analyze on a regular base and the last run was this
> morning.
> 
> if the performance is going down again, i'll contact the postgres people.
> 
> Thanks
> walter
> 
> 
> 
> 
> 
> 
> 
> 
> --
> View this message in context:
> http://osgeo-org.1560.x6.nabble.com/Trouble-with-PostGis-plugin-tp5166669p
> 5171236.html Sent from the Quantum GIS - Developer mailing list archive at
> Nabble.com. _______________________________________________
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-developer