Re: [Maposmatic-dev] Re: PostGIS help for MapOSMatic

[David MENTRE]

Hello,

2010/3/1 Vincent Picavet <address@hidden>:
> 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.