[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Maposmatic-dev] Re: PostGIS help for MapOSMatic
From: |
David MENTRE |
Subject: |
Re: [Maposmatic-dev] Re: PostGIS help for MapOSMatic |
Date: |
Mon, 1 Mar 2010 19:22:32 +0100 |
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.