Revision 1654
Added by Aaron Marcuse-Kubitza almost 13 years ago
schemas/postgresql.conf | ||
---|---|---|
104 | 104 |
|
105 | 105 |
# - Memory - |
106 | 106 |
|
107 |
shared_buffers = 24MB # min 128kB |
|
107 |
# Set to SHMMAX |
|
108 |
shared_buffers = 4GB # min 128kB |
|
108 | 109 |
# (change requires restart) |
109 | 110 |
#temp_buffers = 8MB # min 800kB |
110 | 111 |
#max_prepared_transactions = 0 # zero disables the feature |
... | ... | |
113 | 114 |
# per transaction slot, plus lock space (see max_locks_per_transaction). |
114 | 115 |
# It is not advisable to set max_prepared_transactions nonzero unless you |
115 | 116 |
# actively intend to use prepared transactions. |
117 |
work_mem = 256MB # min 64kB |
|
116 | 118 |
#work_mem = 1MB # min 64kB |
119 |
maintenance_work_mem = 256MB # min 1MB |
|
117 | 120 |
#maintenance_work_mem = 16MB # min 1MB |
118 | 121 |
#max_stack_depth = 2MB # min 100kB |
119 | 122 |
|
... | ... | |
149 | 152 |
# - Settings - |
150 | 153 |
|
151 | 154 |
#fsync = on # turns forced synchronization on or off |
152 |
#synchronous_commit = on # immediate fsync at commit |
|
155 |
##### WARNING: Switching this off may cause data loss. |
|
156 |
# It is used to improve performance with frequent commits. Each datasource makes |
|
157 |
# ~10 commits/sec (which will hopefully increase after optimization), and there |
|
158 |
# can be 10+ datasources running simultaneously, so the 100 commit/sec limit may |
|
159 |
# be exceeded. See synchronous_commit at |
|
160 |
# <http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server#synchronous_commit> |
|
161 |
##### |
|
162 |
synchronous_commit = off # immediate fsync at commit |
|
153 | 163 |
#wal_sync_method = fsync # the default is the first option |
154 | 164 |
# supported by the operating system: |
155 | 165 |
# open_datasync |
... | ... | |
204 | 214 |
#cpu_tuple_cost = 0.01 # same scale as above |
205 | 215 |
#cpu_index_tuple_cost = 0.005 # same scale as above |
206 | 216 |
#cpu_operator_cost = 0.0025 # same scale as above |
217 |
effective_cache_size = 12GB |
|
207 | 218 |
#effective_cache_size = 128MB |
208 | 219 |
|
209 | 220 |
# - Genetic Query Optimizer - |
Also available in: Unified diff
schemas/postgresql.conf: Optimized again using same changes as were applied to 8.4 version