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

Timestamp:

08/31/10 14:48:47 (14 years ago)

Author:

Fran Boon

Comment:

--

GIS/InstallationGuidelines/Linux

@@ -46 +46 @@
  * Adjust postgresql.conf for performance relative to resources available (http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server)
 {{{
+vim /etc/sysctl.conf
+# Increase Shared Memory available for PostgreSQL
+# 512Mb (56Mb shared_buffers)
+kernel.shmmax = 58720256
+# 1024Mb (160Mb shared_buffers)
+#kernel.shmmax = 167772160
+kernel.shmall = 2097152
+
+sysctl -w kernel.shmmax=58720256
+sysctl -w kernel.shmall=2097152
+
 vim /etc/postgresql/8.3/main/postgresql.conf
-
 
 # This default is probably ok
@@ -69 +79 @@
 # 1024Mb system suggest starting at:
 #effective_cache_size = 512MB
-
 
 #work_mem = 1MB