taskMapOSMatic - Tasks: task #9738, tweak database config

 
 

task #9738: tweak database config

Submitter:  David Decotigny <daviddecotigny>
Submitted:  Wed 23 Sep 2009 08:46:02 AM UTC
   
 
Should Start On:  Wed 23 Sep 2009 12:00:00 AM UTC Should be Finished on:  Wed 23 Sep 2009 12:00:00 AM UTC
Category:  database Priority:  * 5 - Normal
Status:  Done Privacy:  Public
Assigned to:  daviddecotigny Percent Complete:  0%
Open/Closed:  Closed Release:  None
Effort:  0.00
* Mandatory Fields

Add a New Comment Rich Markup
   

Fri 02 Oct 2009 04:43:17 PM UTC, comment #2: 

Following a suggestion from V. Meurisse on osm-talk-fr, I also tried to tweak the system: rw,noatime,data=writeback
But this didin't help so much (apparently):
real 541m32.575s
user 6m48.382s
sys 5m36.021s

David Decotigny <daviddecotigny>
Group administrator
Thu 24 Sep 2009 06:59:13 AM UTC, comment #1: 

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.

David Decotigny <daviddecotigny>
Group administrator
Wed 23 Sep 2009 08:46:02 AM UTC, original submission:  
David Decotigny <daviddecotigny>
Group administrator

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

Attach Files:
   
   
Comment:
   

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

Carbon-Copy List
  • -email is unavailable- added by dmentre (Updated the item)
  • -email is unavailable- added by daviddecotigny (Submitted the item)
  •  

    There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

    Only logged-in users can vote.

     

    Follow 2 latest changes.

    Date Changed by Updated Field Previous Value => Replaced by
    2010-01-07 dmentre StatusNeed Info Done
        Open/ClosedOpen Closed

    Back to the top

    Powered by Savane 3.13-d3ae.
    Corresponding source code