Revision 1653
Added by Aaron Marcuse-Kubitza almost 13 years ago
| schemas/postgresql.conf | ||
|---|---|---|
| 38 | 38 |
# The default values of these variables are driven from the -D command-line |
| 39 | 39 |
# option or PGDATA environment variable, represented here as ConfigDir. |
| 40 | 40 |
|
| 41 |
data_directory = '/var/lib/postgresql/8.4/main' # use data in another directory
|
|
| 41 |
data_directory = '/var/lib/postgresql/9.1/main' # use data in another directory
|
|
| 42 | 42 |
# (change requires restart) |
| 43 |
hba_file = '/etc/postgresql/8.4/main/pg_hba.conf' # host-based authentication file
|
|
| 43 |
hba_file = '/etc/postgresql/9.1/main/pg_hba.conf' # host-based authentication file
|
|
| 44 | 44 |
# (change requires restart) |
| 45 |
ident_file = '/etc/postgresql/8.4/main/pg_ident.conf' # ident configuration file
|
|
| 45 |
ident_file = '/etc/postgresql/9.1/main/pg_ident.conf' # ident configuration file
|
|
| 46 | 46 |
# (change requires restart) |
| 47 | 47 |
|
| 48 | 48 |
# If external_pid_file is not explicitly set, no extra PID file is written. |
| 49 |
external_pid_file = '/var/run/postgresql/8.4-main.pid' # write an extra PID file
|
|
| 49 |
external_pid_file = '/var/run/postgresql/9.1-main.pid' # write an extra PID file
|
|
| 50 | 50 |
# (change requires restart) |
| 51 | 51 |
|
| 52 | 52 |
|
| ... | ... | |
| 104 | 104 |
|
| 105 | 105 |
# - Memory - |
| 106 | 106 |
|
| 107 |
# Set to SHMMAX |
|
| 108 |
shared_buffers = 4GB # min 128kB |
|
| 107 |
shared_buffers = 24MB # min 128kB |
|
| 109 | 108 |
# (change requires restart) |
| 110 | 109 |
#temp_buffers = 8MB # min 800kB |
| 111 | 110 |
#max_prepared_transactions = 0 # zero disables the feature |
| ... | ... | |
| 114 | 113 |
# per transaction slot, plus lock space (see max_locks_per_transaction). |
| 115 | 114 |
# It is not advisable to set max_prepared_transactions nonzero unless you |
| 116 | 115 |
# actively intend to use prepared transactions. |
| 117 |
work_mem = 256MB # min 64kB |
|
| 118 | 116 |
#work_mem = 1MB # min 64kB |
| 119 |
maintenance_work_mem = 256MB # min 1MB |
|
| 120 | 117 |
#maintenance_work_mem = 16MB # min 1MB |
| 121 | 118 |
#max_stack_depth = 2MB # min 100kB |
| 122 | 119 |
|
| ... | ... | |
| 152 | 149 |
# - Settings - |
| 153 | 150 |
|
| 154 | 151 |
#fsync = on # turns forced synchronization on or off |
| 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 |
|
| 152 |
#synchronous_commit = on # immediate fsync at commit |
|
| 163 | 153 |
#wal_sync_method = fsync # the default is the first option |
| 164 | 154 |
# supported by the operating system: |
| 165 | 155 |
# open_datasync |
| ... | ... | |
| 214 | 204 |
#cpu_tuple_cost = 0.01 # same scale as above |
| 215 | 205 |
#cpu_index_tuple_cost = 0.005 # same scale as above |
| 216 | 206 |
#cpu_operator_cost = 0.0025 # same scale as above |
| 217 |
effective_cache_size = 12GB |
|
| 218 | 207 |
#effective_cache_size = 128MB |
| 219 | 208 |
|
| 220 | 209 |
# - Genetic Query Optimizer - |
Also available in: Unified diff
schemas/postgresql.conf: Replaced with original 9.1 version