-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Peter Körner:
After an ANALYZE it does an Index Scan, but this is
not really faster:
I've replaced the partial index with a standard index on pending, for
both planet_osm_ways and planet_osm_rel. This seems to improve the
query speed:
osm_mapnik=# explain analyze select id from planet_osm_ways where pending;
QUERY PLAN
-
------------------------------------------------------------------------------------------------------------------------------------------
Index Scan using planet_osm_ways_pending on planet_osm_ways (cost=0.00..12.84 rows=1
width=4) (actual time=0.248..0.248 rows=0 loops=1)
Index Cond: (pending = true)
Filter: pending
Total runtime: 0.263 ms
(4 rows)
Does this improve the diff import time at all?
- river.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (HP-UX)
iEYEARECAAYFAkuC8IAACgkQIXd7fCuc5vIXuwCdHd1UgVjXPqilZgqMe7cnHOZw
NJgAniq9ioIuI3lNp6mABESHFmp2R/ps
=MMch
-----END PGP SIGNATURE-----