gistify941688.sh

~/Downloads ❯ diff staging.conf production.conf
diff --git a/staging.conf b/production.conf
index 0f23dc9..3844f53 100644
--- a/staging.conf
+++ b/production.conf
@@ -1,4 +1,4 @@
-[root@peyote-staging-db10 data]# cat postgresql.conf
+[root@peyote-production-db03 data]# cat postgresql.conf
 # Generated by Sprinkle, do not edit manually
 #
 # -----------------------------
@@ -109,7 +109,7 @@ ssl_renegotiation_limit = 0  # amount of data between renegotiations
 
 # - Memory -
 
-shared_buffers = 7GB      # min 128kB
+shared_buffers = 960MB      # min 128kB
           # (change requires restart)
 #temp_buffers = 8MB     # min 800kB
 #max_prepared_transactions = 0    # zero disables the feature
@@ -118,8 +118,8 @@ shared_buffers = 7GB      # min 128kB
 # per transaction slot, plus lock space (see max_locks_per_transaction).
 # It is not advisable to set max_prepared_transactions nonzero unless you
 # actively intend to use prepared transactions.
-work_mem = 240MB       # min 64kB
-maintenance_work_mem = 1792MB    # min 1MB
+work_mem = 384MB       # min 64kB
+maintenance_work_mem = 240MB    # min 1MB
 #max_stack_depth = 2MB      # min 100kB
 
 # - Kernel Resource Usage -
@@ -165,7 +165,7 @@ synchronous_commit = off    # immediate fsync at commit
           #   fsync_writethrough
           #   open_sync
 #full_page_writes = on      # recover from partial page writes
-wal_buffers = 64MB     # min 32kB
+wal_buffers = 16MB     # min 32kB
           # (change requires restart)
 #wal_writer_delay = 200ms   # 1-10000 milliseconds
 
@@ -174,7 +174,7 @@ wal_buffers = 64MB     # min 32kB
 
 # - Checkpoints -
 
-checkpoint_segments = 256    # in logfile segments, min 1, 16MB each
+checkpoint_segments = 32    # in logfile segments, min 1, 16MB each
 #checkpoint_timeout = 5min    # range 30s-1h
 checkpoint_completion_target = 0.9 # checkpoint target duration, 0.0 - 1.0
 #checkpoint_warning = 30s   # 0 disables
@@ -231,7 +231,7 @@ random_page_cost = 2.0     # same scale as above
 #cpu_tuple_cost = 0.01      # same scale as above
 #cpu_index_tuple_cost = 0.005   # same scale as above
 #cpu_operator_cost = 0.0025   # same scale as above
-effective_cache_size = 22GB
+effective_cache_size = 2816MB
 
 # - Genetic Query Optimizer -
 
@@ -528,5 +528,4 @@ default_text_search_config = 'pg_catalog.english'
 # CUSTOMIZED OPTIONS
 #------------------------------------------------------------------------------
 
-#custom_variable_classes = ''   # list of custom variable class names[root@peyote-staging-db10 data]#
-#custom_variable_classes = ''   # list of custom variable class names[root@peyote-staging-db10 data]#
\ No newline at end of file
+#custom_variable_classes = ''   # list of custom variable class names[root@peyote-production-db03 data]#
\ No newline at end of file
~