[OSM-dev] Postgres 8.4/PostGIS 1.4 performance

Frederik Ramm frederik at remote.org
Sun Sep 20 18:43:44 BST 2009


Hi,

Lars Francke wrote:
> 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?

Bye
Frederik





More information about the dev mailing list