Hello,
2010/3/1 Vincent Picavet <[email protected]>:
> Could you try creating the following index, analyze planet_osm_line and
> re-run the original query ?
>
> create index idx_pol_citybound on planet_osm_line (name) where
> boundary='administrative' and admin_level='8';
We already have this index:
"""
-- Create a partial index to speed up the city name lookups (a few
-- milliseconds versus a few minutes):
create index admin_city_names
on planet_osm_line (boundary,admin_level,name)
where (boundary='administrative' and admin_level='8');
"""
Is it enough?
Best regards,
d.
