[postgis-users] Strange Performance issue

Markus Schaber schabi at logix-tt.com
Thu Oct 13 05:52:57 PDT 2005

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?


More information about the postgis-users mailing list