-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Peter Körner:
Has the table
been ANALYZEd since it was imported?
Only if
the osm2pgsql tool did it. It contains a function, pgsql_analyze, for
this, but I'm unsure if it got / when it gets called.
osm_mapnik=# explain analyze select id from planet_osm_ways where pending;
QUERY PLAN
-
--------------------------------------------------------------------------------------------------------------------------------
Seq Scan on planet_osm_ways (cost=0.00..1662990.31 rows=22160666 width=4) (actual
time=496448.422..496448.422 rows=0 loops=1)
Filter: pending
Total runtime: 496448.455 ms
This suggests that the table statistics are very out of date (22m rows
expected vs 0 actual). I suggest ANALYZEing the table and trying the
diff import again.
- river.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (HP-UX)
iEYEARECAAYFAkuCuqIACgkQIXd7fCuc5vLX/ACcCKAfD+/X197OOMOikdylNunG
Q2oAnAsOHcVefUENUEjGd1lzEtd1l0nR
=o2RI
-----END PGP SIGNATURE-----