Changes between Version 82 and Version 83 of InstallationGuidelines/PostgreSQL

Timestamp:

02/14/18 08:59:01 (7 years ago)

Author:

Fran Boon

Comment:

--

InstallationGuidelines/PostgreSQL

@@ -92 +92 @@
 # Values suggested are quite conservative, so you can push them up a bit if there are resources available for it
 # but absolutely no more than 1/3 available memory.
-# 512Mb/1024 Mb system suggest starting at default:
+# 512Mb Mb system suggest starting at default:
 shared_buffers = 128MB
 # 1024 Mb system suggest starting at:
@@ -98 +98 @@
 # 8096Mb system suggest starting at:
 #shared_buffers = 1024MB
-
-# effective_cache_size = 4GB
-# 75% of available memory
-# 512Mb system suggest starting at:
-effective_cache_size = 256MB
-# 1024Mb system suggest starting at:
-#effective_cache_size = 512MB
-# 8096Mb system suggest starting at default:
-#effective_cache_size = 4GB
 
 #work_mem = 4MB
@@ -125 +116 @@
 #maintenance_work_mem = 128MB
 
+min_wal_size = 1GB
+max_wal_size = 2GB
+# Improve write performance
+#checkpoint_completion_target = 0.5
+checkpoint_completion_target = 0.7
+
+# effective_cache_size = 4GB
+# 75% of available memory
+# 512Mb system suggest starting at:
+effective_cache_size = 256MB
+# 1024Mb system suggest starting at:
+#effective_cache_size = 512MB
+# 8096Mb system suggest starting at default:
+#effective_cache_size = 4GB
+
 /etc/init.d/postgresql restart
 }}}