>> On a related note: There was a change between PostgreSQL 8.3 and 8.4 >> which increased the default_statistics_target from 10 to 100 and its >> maximum from 1.000 to 10.000 which makes ANALYZE runs take longer but >> at least for me it helps a lot. > > Have you, too, noticed the 10% performance degradation (of 8.4 vs. 8.3) on > full planet imports that prompted me to start this thread?
I'm sorry I never measured the time and I had to downgrade to 8.3 for the time being for other reasons. Lars _______________________________________________ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev