[Qgis-developer] Trouble with PostGis

[Hugo Mercier]

Le 04/11/2014 21:27, walter.nordmann a écrit :
> Sandro Santilli-2 wrote
>> You'll need to show the query and the definition of the tables
>> involved in it (EXPLAIN 
>> <query>
>>  output also helps).
> 
> that is exactly what i did. you can see the query and the explain-output one
> post before.
> 
> and here ist the table definition:
> 
> 

Hi,

I don't know exactly why, but the code you inserted in your messages are
not visible. They are only visible when using the web-based archives
like nabble ...

So apparently you have filters on geometries (with intersection test &&)
but no spatial index on these geometries.
Something like CREATE INDEX ON table USING GIST(way) could help