[OSM-dev] osm2pgsql diff imports benchmarks

[sly (sylvain letuffe)]

> > 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