Skip to content

Instantly share code, notes, and snippets.

@ajashton
Created November 7, 2012 21:37
Show Gist options
  • Save ajashton/4034662 to your computer and use it in GitHub Desktop.
Save ajashton/4034662 to your computer and use it in GitHub Desktop.
diff --git a/storm/postgresql.conf b/storm/postgresql.conf
index 37d26ef..7b68c5e 100644
--- a/storm/postgresql.conf
+++ b/storm/postgresql.conf
@@ -106,7 +106,7 @@ ssl = false # (change requires restart)
# - Memory -
-shared_buffers = 4GB # min 128kB
+shared_buffers = 8MB # min 128kB
# (change requires restart)
#temp_buffers = 8MB # min 800kB
#max_prepared_transactions = 0 # zero disables the feature
@@ -116,7 +116,7 @@ shared_buffers = 4GB # min 128kB
# It is not advisable to set max_prepared_transactions nonzero unless you
# actively intend to use prepared transactions.
#work_mem = 1MB # min 64kB
-#maintenance_work_mem = 16MB # min 1MB
+maintenance_work_mem = 4GB # min 1MB
#max_stack_depth = 2MB # min 100kB
# - Kernel Resource Usage -
@@ -152,7 +152,7 @@ shared_buffers = 4GB # min 128kB
#wal_level = minimal # minimal, archive, or hot_standby
# (change requires restart)
-#fsync = on # turns forced synchronization on or off
+fsync = off # turns forced synchronization on or off
#synchronous_commit = on # synchronization level; on, off, or local
#wal_sync_method = fsync # the default is the first option
# supported by the operating system:
@@ -241,7 +241,7 @@ shared_buffers = 4GB # min 128kB
# - Planner Cost Constants -
#seq_page_cost = 1.0 # measured on an arbitrary scale
-#random_page_cost = 4.0 # same scale as above
+random_page_cost = 1.1 # 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
@@ -566,7 +566,7 @@ work_mem = 128MB
# Writing
maintenance_work_mem = 512MB
-checkpoint_segments = 30
+checkpoint_segments = 60
# Disable autovacuum
autovacuum = off
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment