Revision 1586
Added by Aaron Marcuse-Kubitza almost 13 years ago
| schemas/postgresql.nimoy.conf | ||
|---|---|---|
| 105 | 105 |
|
| 106 | 106 |
# - Memory - |
| 107 | 107 |
|
| 108 |
shared_buffers = 24MB # min 128kB or max_connections*16kB
|
|
| 108 |
shared_buffers = 2GB # min 128kB or max_connections*16kB
|
|
| 109 | 109 |
# (change requires restart) |
| 110 | 110 |
#temp_buffers = 8MB # min 800kB |
| 111 | 111 |
#max_prepared_transactions = 5 # can be 0 or more |
| ... | ... | |
| 151 | 151 |
# - Settings - |
| 152 | 152 |
|
| 153 | 153 |
#fsync = on # turns forced synchronization on or off |
| 154 |
#synchronous_commit = on # immediate fsync at commit |
|
| 154 |
##### WARNING: Switching this off may cause data loss. |
|
| 155 |
# It is used to improve performance with frequent commits. Each datasource makes |
|
| 156 |
# ~10 commits/sec (which will hopefully increase after optimization), and there |
|
| 157 |
# can be 10+ datasources running simultaneously, so the 100 commit/sec limit may |
|
| 158 |
# be exceeded. See synchronous_commit at |
|
| 159 |
# <http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server#synchronous_commit> |
|
| 160 |
##### |
|
| 161 |
synchronous_commit = off # immediate fsync at commit |
|
| 155 | 162 |
#wal_sync_method = fsync # the default is the first option |
| 156 | 163 |
# supported by the operating system: |
| 157 | 164 |
# open_datasync |
| ... | ... | |
| 206 | 213 |
#cpu_tuple_cost = 0.01 # same scale as above |
| 207 | 214 |
#cpu_index_tuple_cost = 0.005 # same scale as above |
| 208 | 215 |
#cpu_operator_cost = 0.0025 # same scale as above |
| 209 |
#effective_cache_size = 128MB
|
|
| 216 |
effective_cache_size = 6GB
|
|
| 210 | 217 |
|
| 211 | 218 |
# - Genetic Query Optimizer - |
| 212 | 219 |
|
Also available in: Unified diff
Optimized schemas/postgresql.nimoy.conf