[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:1.9.0.14) 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:
<http://savannah.nongnu.org/task/?9738>
_______________________________________________
Message sent via/by Savannah
http://savannah.nongnu.org/