Changes between Version 6 and Version 7 of GIS/InstallationGuidelines/Linux


Ignore:
Timestamp:
08/31/10 14:48:47 (11 years ago)
Author:
Fran Boon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • GIS/InstallationGuidelines/Linux

    v6 v7  
    4646 * Adjust postgresql.conf for performance relative to resources available (http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server)
    4747{{{
     48vim /etc/sysctl.conf
     49# Increase Shared Memory available for PostgreSQL
     50# 512Mb (56Mb shared_buffers)
     51kernel.shmmax = 58720256
     52# 1024Mb (160Mb shared_buffers)
     53#kernel.shmmax = 167772160
     54kernel.shmall = 2097152
     55
     56sysctl -w kernel.shmmax=58720256
     57sysctl -w kernel.shmall=2097152
     58
    4859vim /etc/postgresql/8.3/main/postgresql.conf
    49 
    5060
    5161# This default is probably ok
     
    6979# 1024Mb system suggest starting at:
    7080#effective_cache_size = 512MB
    71 
    7281
    7382#work_mem = 1MB