[OSM-dev] Postgres 8.4/PostGIS 1.4 performance

Lars Francke lars.francke at gmail.com
Mon Sep 21 13:53:39 BST 2009


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




More information about the dev mailing list