[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Maposmatic-dev] [task #9738] tweak database config

From: David Decotigny
Subject: [Maposmatic-dev] [task #9738] tweak database config
Date: Thu, 24 Sep 2009 06:59:13 +0000
User-agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv: Gecko/2009090216 Ubuntu/8.10 (intrepid) Firefox/3.0.14

Follow-up Comment #1, task #9738 (project maposmatic):

Ran an update with the following tweaks in the pgsql config:

checkpoint_segments = 32
effective_cache_size = 640MB
fsync = off
maintenance_work_mem = 512MB
shared_buffers = 512MB
temp_buffers = 100MB
wal_buffers = 128kB
work_mem = 100MB

With a slight change in sysctl:
kernel.shmmax = 671088640

With that config, only a (almost) negligible change:
real    521m42.875s
user    5m44.170s
sys     5m7.111s
Instead of (but with a different diff file):
real    545m49.453s
user    6m10.855s
sys     5m34.673s

We'll probably have to limit ourselves to the europe area.


Reply to this item at:


  Message sent via/by Savannah

reply via email to

[Prev in Thread] Current Thread [Next in Thread]