|
|
Runtime configuration: Performance
- Optimiser related
- enable_seqscan, enable_indexscan, enable_tidscan, enable_sort, enable_nestloop, enable_mergejoin, enable_hashjoin: enable/disable respective mechanisms
- effective_cache_size: number of 8K disk blocks the optimiser assumes that the kernel caches
- random_page_cost: unit cost of retrieving a page from disk
- cpu_tuple_cost: CPU cost per tuple retrieved
- cpu_index_tuple_cost: CPU cost per inde tuple retrieved
- cpu_operator_cost: CPU cost of processing an operator in a WHERE clause
Page 18
|