|
48 | 48 | #
|
49 | 49 | #Shared Memory Size
|
50 | 50 | #
|
51 |
| -#shared_buffers = 64# 2*max_connections, min 16, 8K each |
| 51 | +#shared_buffers = 64# 2*max_connections, min 16,typically8K each |
52 | 52 | #max_fsm_relations = 100# min 10, fsm is free space map
|
53 | 53 | #max_fsm_pages = 10000# min 1000, fsm is free space map
|
54 | 54 | #max_locks_per_transaction = 64# min 10
|
55 |
| -#wal_buffers = 8# min 4, 8K each |
| 55 | +#wal_buffers = 8# min 4,typically8K each |
56 | 56 |
|
57 | 57 | #
|
58 | 58 | #Non-shared Memory Sizes
|
|
89 | 89 | #enable_mergejoin = true
|
90 | 90 | #enable_hashjoin = true
|
91 | 91 |
|
92 |
| -#effective_cache_size = 1000# 8K each |
93 |
| -#random_page_cost = 4 |
94 |
| -#cpu_tuple_cost = 0.01 |
95 |
| -#cpu_index_tuple_cost = 0.001 |
96 |
| -#cpu_operator_cost = 0.0025 |
| 92 | +#effective_cache_size = 1000#typically8K each |
| 93 | +#random_page_cost = 4# units are one sequential page fetch cost |
| 94 | +#cpu_tuple_cost = 0.01# (same) |
| 95 | +#cpu_index_tuple_cost = 0.001# (same) |
| 96 | +#cpu_operator_cost = 0.0025# (same) |
97 | 97 |
|
98 | 98 | #default_statistics_target = 10# range 1-1000
|
99 | 99 |
|
|