[OSM-dev] [PATCH] osm2pgsql tile expiry

[Steve Hill]

On Sun, 8 Feb 2009, Martijn van Oosterhout wrote:

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

Yes, I actually have the shared buffers set to 512MB at the moment, 
although Postgresql doesn't seem to actually be using anything close to 
that much.

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

The database server currently has about 1.2GB, so maybe it could do with 
some more.

  - Steve
    xmpp:steve at nexusuk.org   sip:steve at nexusuk.org   http://www.nexusuk.org/

      Servatis a periculum, servatis a maleficum - Whisper, Evanescence