[OSM-dev] [PATCH] osm2pgsql tile expiry

Martijn van Oosterhout kleptog at gmail.com
Sun Feb 8 15:33:28 GMT 2009

On Sun, Feb 8, 2009 at 3:04 PM, Steve Hill <steve at nexusuk.org> wrote:
> I've got some significant database performance problems on my system in
> general to be honest - I think I'm going to have to spend some time tuning
> the DB.  My server seems to be unable to keep up with the OSM updates during
> the day (it gradually falls behind during the day and then catches up again
> overnight: http://openpistemap.org/updategraph ).  The database server seems
> to be totally I/O bound most of the time.

Have you tuned the database at all according to what's on the
http://wiki.openstreetmap.org/wiki/Mapnik/PostGIS page? If you don't
increase the shared_memory setting then postgres is going to spend the
whole time swapping various indexes in and out of memory.

Any server with 2GB of memory has to be able to keep up I think...

Have a nice day,
Martijn van Oosterhout <kleptog at gmail.com> http://svana.org/kleptog/

More information about the dev mailing list