使用英语阅读

Query Tuning / Other Planner Options

  • 2025/05/19
选择 PostgreSQL 版本

constraint_exclusion

Attribute Value
Category Query Tuning / Other Planner Options
Description Controls the query planner's use of table constraints to optimize queries.
Data type enumeration
Default value partition
Allowed values partition,on,off
Parameter type dynamic
Documentation constraint_exclusion

cursor_tuple_fraction

Attribute Value
Category Query Tuning / Other Planner Options
Description Sets the planner's estimate of the fraction of a cursor's rows that will be retrieved.
Data type numeric
Default value 0.1
Allowed values 0-1
Parameter type dynamic
Documentation cursor_tuple_fraction

default_statistics_target

Attribute Value
Category Query Tuning / Other Planner Options
Description Sets the default statistics target for table columns without a column-specific target.
Data type integer
Default value 100
Allowed values 1-10000
Parameter type dynamic
Documentation default_statistics_target

from_collapse_limit

Attribute Value
Category Query Tuning / Other Planner Options
Description The planner will merge sub-queries into upper queries upto this limit in FROM clause. Smaller values reduce planning time but might yield inferior query plans.
Data type integer
Default value 8
Allowed values 1-2147483647
Parameter type dynamic
Documentation from_collapse_limit

jit

Attribute Value
Category Query Tuning / Other Planner Options
Description Determines whether JIT compilation may be used by PostgreSQL.
Data type boolean
Default value off
Allowed values on, off
Parameter type dynamic
Documentation jit

join_collapse_limit

Attribute Value
Category Query Tuning / Other Planner Options
Description Sets the FROM-list size beyond which JOIN constructs are not flattened.
Data type integer
Default value 8
Allowed values 1-2147483647
Parameter type dynamic
Documentation join_collapse_limit

plan_cache_mode

Attribute Value
Category Query Tuning / Other Planner Options
Description Controls the planner's selection of custom or generic plan.
Data type enumeration
Default value auto
Allowed values auto,force_generic_plan,force_custom_plan
Parameter type dynamic
Documentation plan_cache_mode

recursive_worktable_factor

Attribute Value
Category Query Tuning / Other Planner Options
Description Sets the planner's estimate of the average size of a recursive query's working table.
Data type numeric
Default value 10
Allowed values 10
Parameter type read-only
Documentation recursive_worktable_factor

constraint_exclusion

Attribute Value
Category Query Tuning / Other Planner Options
Description Controls the query planner's use of table constraints to optimize queries.
Data type enumeration
Default value partition
Allowed values partition,on,off
Parameter type dynamic
Documentation constraint_exclusion

cursor_tuple_fraction

Attribute Value
Category Query Tuning / Other Planner Options
Description Sets the planner's estimate of the fraction of a cursor's rows that will be retrieved.
Data type numeric
Default value 0.1
Allowed values 0-1
Parameter type dynamic
Documentation cursor_tuple_fraction

default_statistics_target

Attribute Value
Category Query Tuning / Other Planner Options
Description Sets the default statistics target for table columns without a column-specific target.
Data type integer
Default value 100
Allowed values 1-10000
Parameter type dynamic
Documentation default_statistics_target

from_collapse_limit

Attribute Value
Category Query Tuning / Other Planner Options
Description The planner will merge sub-queries into upper queries upto this limit in FROM clause. Smaller values reduce planning time but might yield inferior query plans.
Data type integer
Default value 8
Allowed values 1-2147483647
Parameter type dynamic
Documentation from_collapse_limit

jit

Attribute Value
Category Query Tuning / Other Planner Options
Description Determines whether JIT compilation may be used by PostgreSQL.
Data type boolean
Default value off
Allowed values on, off
Parameter type dynamic
Documentation jit

join_collapse_limit

Attribute Value
Category Query Tuning / Other Planner Options
Description Sets the FROM-list size beyond which JOIN constructs are not flattened.
Data type integer
Default value 8
Allowed values 1-2147483647
Parameter type dynamic
Documentation join_collapse_limit

plan_cache_mode

Attribute Value
Category Query Tuning / Other Planner Options
Description Controls the planner's selection of custom or generic plan.
Data type enumeration
Default value auto
Allowed values auto,force_generic_plan,force_custom_plan
Parameter type dynamic
Documentation plan_cache_mode

recursive_worktable_factor

Attribute Value
Category Query Tuning / Other Planner Options
Description Sets the planner's estimate of the average size of a recursive query's working table.
Data type numeric
Default value 10
Allowed values 10
Parameter type read-only
Documentation recursive_worktable_factor

constraint_exclusion

Attribute Value
Category Query Tuning / Other Planner Options
Description Controls the query planner's use of table constraints to optimize queries.
Data type enumeration
Default value partition
Allowed values partition,on,off
Parameter type dynamic
Documentation constraint_exclusion

cursor_tuple_fraction

Attribute Value
Category Query Tuning / Other Planner Options
Description Sets the planner's estimate of the fraction of a cursor's rows that will be retrieved.
Data type numeric
Default value 0.1
Allowed values 0-1
Parameter type dynamic
Documentation cursor_tuple_fraction

default_statistics_target

Attribute Value
Category Query Tuning / Other Planner Options
Description Sets the default statistics target for table columns without a column-specific target.
Data type integer
Default value 100
Allowed values 1-10000
Parameter type dynamic
Documentation default_statistics_target

from_collapse_limit

Attribute Value
Category Query Tuning / Other Planner Options
Description The planner will merge sub-queries into upper queries upto this limit in FROM clause. Smaller values reduce planning time but might yield inferior query plans.
Data type integer
Default value 8
Allowed values 1-2147483647
Parameter type dynamic
Documentation from_collapse_limit

jit

Attribute Value
Category Query Tuning / Other Planner Options
Description Determines whether JIT compilation may be used by PostgreSQL.
Data type boolean
Default value off
Allowed values on, off
Parameter type dynamic
Documentation jit

join_collapse_limit

Attribute Value
Category Query Tuning / Other Planner Options
Description Sets the FROM-list size beyond which JOIN constructs are not flattened.
Data type integer
Default value 8
Allowed values 1-2147483647
Parameter type dynamic
Documentation join_collapse_limit

plan_cache_mode

Attribute Value
Category Query Tuning / Other Planner Options
Description Controls the planner's selection of custom or generic plan.
Data type enumeration
Default value auto
Allowed values auto,force_generic_plan,force_custom_plan
Parameter type dynamic
Documentation plan_cache_mode

constraint_exclusion

Attribute Value
Category Query Tuning / Other Planner Options
Description Controls the query planner's use of table constraints to optimize queries.
Data type enumeration
Default value partition
Allowed values partition,on,off
Parameter type dynamic
Documentation constraint_exclusion

cursor_tuple_fraction

Attribute Value
Category Query Tuning / Other Planner Options
Description Sets the planner's estimate of the fraction of a cursor's rows that will be retrieved.
Data type numeric
Default value 0.1
Allowed values 0-1
Parameter type dynamic
Documentation cursor_tuple_fraction

default_statistics_target

Attribute Value
Category Query Tuning / Other Planner Options
Description Sets the default statistics target for table columns without a column-specific target.
Data type integer
Default value 100
Allowed values 1-10000
Parameter type dynamic
Documentation default_statistics_target

from_collapse_limit

Attribute Value
Category Query Tuning / Other Planner Options
Description The planner will merge sub-queries into upper queries upto this limit in FROM clause. Smaller values reduce planning time but might yield inferior query plans.
Data type integer
Default value 8
Allowed values 1-2147483647
Parameter type dynamic
Documentation from_collapse_limit

jit

Attribute Value
Category Query Tuning / Other Planner Options
Description Determines whether JIT compilation may be used by PostgreSQL.
Data type boolean
Default value off
Allowed values on, off
Parameter type dynamic
Documentation jit

join_collapse_limit

Attribute Value
Category Query Tuning / Other Planner Options
Description Sets the FROM-list size beyond which JOIN constructs are not flattened.
Data type integer
Default value 8
Allowed values 1-2147483647
Parameter type dynamic
Documentation join_collapse_limit

plan_cache_mode

Attribute Value
Category Query Tuning / Other Planner Options
Description Controls the planner's selection of custom or generic plan.
Data type enumeration
Default value auto
Allowed values auto,force_generic_plan,force_custom_plan
Parameter type dynamic
Documentation plan_cache_mode

constraint_exclusion

Attribute Value
Category Query Tuning / Other Planner Options
Description Controls the query planner's use of table constraints to optimize queries.
Data type enumeration
Default value partition
Allowed values partition,on,off
Parameter type dynamic
Documentation constraint_exclusion

cursor_tuple_fraction

Attribute Value
Category Query Tuning / Other Planner Options
Description Sets the planner's estimate of the fraction of a cursor's rows that will be retrieved.
Data type numeric
Default value 0.1
Allowed values 0-1
Parameter type dynamic
Documentation cursor_tuple_fraction

default_statistics_target

Attribute Value
Category Query Tuning / Other Planner Options
Description Sets the default statistics target for table columns without a column-specific target.
Data type integer
Default value 100
Allowed values 1-10000
Parameter type dynamic
Documentation default_statistics_target

from_collapse_limit

Attribute Value
Category Query Tuning / Other Planner Options
Description The planner will merge sub-queries into upper queries upto this limit in FROM clause. Smaller values reduce planning time but might yield inferior query plans.
Data type integer
Default value 8
Allowed values 1-2147483647
Parameter type dynamic
Documentation from_collapse_limit

jit

Attribute Value
Category Query Tuning / Other Planner Options
Description Determines whether JIT compilation may be used by PostgreSQL.
Data type boolean
Default value off
Allowed values on, off
Parameter type dynamic
Documentation jit

join_collapse_limit

Attribute Value
Category Query Tuning / Other Planner Options
Description Sets the FROM-list size beyond which JOIN constructs are not flattened.
Data type integer
Default value 8
Allowed values 1-2147483647
Parameter type dynamic
Documentation join_collapse_limit

plan_cache_mode

Attribute Value
Category Query Tuning / Other Planner Options
Description Controls the planner's selection of custom or generic plan.
Data type enumeration
Default value auto
Allowed values auto,force_generic_plan,force_custom_plan
Parameter type dynamic
Documentation plan_cache_mode

constraint_exclusion

Attribute Value
Category Query Tuning / Other Planner Options
Description Controls the query planner's use of table constraints to optimize queries.
Data type enumeration
Default value partition
Allowed values partition,on,off
Parameter type dynamic
Documentation constraint_exclusion

cursor_tuple_fraction

Attribute Value
Category Query Tuning / Other Planner Options
Description Sets the planner's estimate of the fraction of a cursor's rows that will be retrieved.
Data type numeric
Default value 0.1
Allowed values 0-1
Parameter type dynamic
Documentation cursor_tuple_fraction

default_statistics_target

Attribute Value
Category Query Tuning / Other Planner Options
Description Sets the default statistics target for table columns without a column-specific target.
Data type integer
Default value 100
Allowed values 1-10000
Parameter type dynamic
Documentation default_statistics_target

from_collapse_limit

Attribute Value
Category Query Tuning / Other Planner Options
Description The planner will merge sub-queries into upper queries upto this limit in FROM clause. Smaller values reduce planning time but might yield inferior query plans.
Data type integer
Default value 8
Allowed values 1-2147483647
Parameter type dynamic
Documentation from_collapse_limit

jit

Attribute Value
Category Query Tuning / Other Planner Options
Description Determines whether JIT compilation may be used by PostgreSQL.
Data type boolean
Default value off
Allowed values on, off
Parameter type dynamic
Documentation jit

join_collapse_limit

Attribute Value
Category Query Tuning / Other Planner Options
Description Sets the FROM-list size beyond which JOIN constructs are not flattened.
Data type integer
Default value 8
Allowed values 1-2147483647
Parameter type dynamic
Documentation join_collapse_limit