|
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 |
|
|