[Qgis-developer] Trouble with PostGis

Sandro Santilli strk at keybit.net
Tue Nov 4 11:25:22 PST 2014


On Tue, Nov 04, 2014 at 11:10:16AM -0800, walter.nordmann wrote:

> The cursor-query does not use the indexes for admin_level and boundary.
> that's nearly like a sequential search (on 159 mio. datarecords).
> 
> But i think, that is a postgresql-problem. Any hints what i can do?

You'll need to show the query and the definition of the tables
involved in it (EXPLAIN <query> output also helps).

--strk;

  ()   Free GIS & Flash consultant/developer
  /\   http://strk.keybit.net/services.html


More information about the Qgis-developer mailing list