Query Tuning / Other Planner Options
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 |
Parameter type | read-only |
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 |
Parameter type | read-only |
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 |
Parameter type | read-only |
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 |
Parameter type | read-only |
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 |
Parameter type | read-only |
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 |
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru