Differences

This shows you the differences between two versions of the page.

--- tutorial:adm:server_preparation_tmp [2020/07/24 08:29]
fiserp [DB server configuration]
+++ tutorial:adm:server_preparation_tmp [2020/07/24 08:35]
fiserp [DB server configuration]
@@ Line 158: / Line 158: @@
   * Adjust DB instance sizing.
-    * In following snippet, we presume the system has 3GB of memory dedicated for the database. **For your deployment, adjust the sizing accordingly. Use a [[https://pgtune.leopard.in.ua/#/|calculator]] if in doubt**.
+    * In following snippet, we presume the system has 3GB of memory dedicated for the database and about 100 db connections. **For your deployment, adjust the sizing accordingly. Use a [[https://pgtune.leopard.in.ua/#/|calculator]] if in doubt**.
     * We also log queries running longer than 200ms.
-In a file ''/data/pgsql/12/data/postgresql.conf'' edit (add those if not exist) lines:
+In a file ''/data/pgsql/12/data/postgresql.conf'' change (or add) following lines:
 <code>
-max_connections = 100			# (change requires restart)
+# This is an EXAMPLE. Use the calculator to adjust for your deployment!
-shared_buffers = 768MB			# min 128kB
+# DB Version: 12
+# OS Type: linux
+# DB Type: web
+# Total Memory (RAM): 3 GB
+# Connections num: 100
+# Data Storage: ssd
+max_connections = 100
+shared_buffers = 768MB
 effective_cache_size = 2304MB
-work_mem = 7864kB
 maintenance_work_mem = 192MB
-min_wal_size = 1GB
-max_wal_size = 2GB
 checkpoint_completion_target = 0.7
 wal_buffers = 16MB
 default_statistics_target = 100
+random_page_cost = 1.1
+effective_io_concurrency = 200
+work_mem = 3932kB
+min_wal_size = 1GB
+max_wal_size = 4GB
 log_min_duration_statement = 200