[OSM-dev] osm2pgsql diff imports benchmarks

sly (sylvain letuffe) liste at letuffe.org
Mon Mar 19 13:20:43 GMT 2012


> > gis=> explain select id from planet_osm_ways where pending;
> >  Index Scan using planet_osm_ways_idx on planet_osm_ways  
> > (cost=0.00..916513.78 rows=43724 width=4)

This is what I've got after a re-index :
gis=# explain select id from planet_osm_ways where pending;
                                          QUERY PLAN
----------------------------------------------------------------------------------------------
 Index Scan using planet_osm_ways_idx on planet_osm_ways  (cost=0.00..1157.47 
rows=1 width=4)
(1 ligne)

and that saves me around ~20 seconds per minute diff



-- 
sly
qui suis-je : http://sly.letuffe.org
email perso : sylvain chez letuffe un point org



More information about the dev mailing list