[postgis-users] Strange Performance issue

[Markus Schaber]

Hi, Jerome,

Jerome Gasperi wrote:
> For example, taking the 1000000 footprint table within France :
> 
>       SELECT count(*) FROM world_1000000, country
>       WHERE country.cntry_name='France'
>       AND the_geom && country.geometry_country;
>    The \timing command gives 2882 results in ~4378 ms

Can you send us the EXPLAIN ANALYZE output of this query?

Thanks,
Markus