[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