> > 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
_______________________________________________
dev mailing list
[email protected]
http://lists.openstreetmap.org/listinfo/dev
