[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


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,

reply via email to

[Prev in Thread] Current Thread [Next in Thread]