Project

General

Profile

« Previous | Next » 

Revision 1654

schemas/postgresql.conf: Optimized again using same changes as were applied to 8.4 version

View differences:

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