Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
Browse files

a bunch of slightly more sane defaults for postgres instances on amazon

  • Loading branch information...
commit caacb2ac9ad2a2fadc1e1840c7c86dd6d357d96c 1 parent 35c74c1
@atmos atmos authored
Showing with 6 additions and 2 deletions.
  1. +6 −2 cookbooks/postgres/files/default/postgresql.conf
View
8 cookbooks/postgres/files/default/postgresql.conf
@@ -114,14 +114,15 @@ shared_buffers = 24MB # min 128kB or max_connections*16kB
# Note: Increasing max_prepared_transactions costs ~600 bytes of shared memory
# per transaction slot, plus lock space (see max_locks_per_transaction).
#work_mem = 1MB # min 64kB
+work_mem = 32MB # min 64kB
#maintenance_work_mem = 16MB # min 1MB
#max_stack_depth = 2MB # min 100kB
# - Free Space Map -
-max_fsm_pages = 153600 # min max_fsm_relations*16, 6 bytes each
+max_fsm_pages = 153600 # min max_fsm_relations*16, 6 bytes each
# (change requires restart)
-#max_fsm_relations = 1000 # min 100, ~70 bytes each
+max_fsm_relations = 10000 # min 100, ~70 bytes each
# (change requires restart)
# - Kernel Resource Usage -
@@ -171,6 +172,7 @@ max_fsm_pages = 153600 # min max_fsm_relations*16, 6 bytes each
# - Checkpoints -
#checkpoint_segments = 3 # in logfile segments, min 1, 16MB each
+checkpoint_segments = 10 # in logfile segments, min 1, 16MB each
#checkpoint_timeout = 5min # range 30s-1h
#checkpoint_completion_target = 0.5 # checkpoint target duration, 0.0 - 1.0
#checkpoint_warning = 30s # 0 is off
@@ -208,6 +210,7 @@ max_fsm_pages = 153600 # min max_fsm_relations*16, 6 bytes each
#cpu_index_tuple_cost = 0.005 # same scale as above
#cpu_operator_cost = 0.0025 # same scale as above
#effective_cache_size = 128MB
+effective_cache_size = 1280MB
# - Genetic Query Optimizer -
@@ -221,6 +224,7 @@ max_fsm_pages = 153600 # min max_fsm_relations*16, 6 bytes each
# - Other Planner Options -
#default_statistics_target = 10 # range 1-1000
+default_statistics_target = 100 # range 1-1000
#constraint_exclusion = off
#from_collapse_limit = 8
#join_collapse_limit = 8 # 1 disables collapsing of explicit
Please sign in to comment.
Something went wrong with that request. Please try again.