pg16 各种规划器类型有多少

郑全

postgres=# select version();
                                                   version                                                   
--------------------------------------------------------------------------------------------------------------
PostgreSQL 16.8 on x86_64-redhat-linux-gnu, compiled by gcc (GCC) 14.2.1 20250110 (Red Hat 14.2.1-7), 64-bit
(1 行记录)



postgres=# select distinct category,count(name)
  from pg_settings                                          
where category like '%Planner%'
  group by category;
                  category                   | count
---------------------------------------------+-------
Query Tuning / Other Planner Options        |     8
Query Tuning / Planner Cost Constants       |    13
Query Tuning / Planner Method Configuration |    21
(3 行记录)

postgres=# select name from pg_settings
  where category like 'Query Tuning / Other Planner Options';
            name            
----------------------------
constraint_exclusion
cursor_tuple_fraction
default_statistics_target
from_collapse_limit
jit
join_collapse_limit
plan_cache_mode
recursive_worktable_factor
(8 行记录)



postgres=# select name from pg_settings
  where category like 'Query Tuning / Planner Cost Constants';
             name            
------------------------------
cpu_index_tuple_cost
cpu_operator_cost
cpu_tuple_cost
effective_cache_size
jit_above_cost
jit_inline_above_cost
jit_optimize_above_cost
min_parallel_index_scan_size
min_parallel_table_scan_size
parallel_setup_cost
parallel_tuple_cost
random_page_cost
seq_page_cost
(13 行记录)




postgres=# select name from pg_settings
  where category like 'Query Tuning / Planner Method Configuration';
              name              
--------------------------------
enable_async_append
enable_bitmapscan
enable_gathermerge
enable_hashagg
enable_hashjoin
enable_incremental_sort
enable_indexonlyscan
enable_indexscan
enable_material
enable_memoize
enable_mergejoin
enable_nestloop
enable_parallel_append
enable_parallel_hash
enable_partition_pruning
enable_partitionwise_aggregate
enable_partitionwise_join
enable_presorted_aggregate
enable_seqscan
enable_sort
enable_tidscan
(21 行记录)