[OSM-dev] [PATCH] osm2pgsql tile expiry
steve at nexusuk.org
Sun Feb 8 16:13:09 GMT 2009
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
> 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
xmpp:steve at nexusuk.org sip:steve at nexusuk.org http://www.nexusuk.org/
Servatis a periculum, servatis a maleficum - Whisper, Evanescence
More information about the dev