Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
constraint_exclusion
| Attribute | Value |
|---|---|
| Category | Query Tuning / Other Planner Options |
| Description | Enables the planner to use constraints to optimize queries. Table scans will be skipped if their constraints guarantee that no rows match the query. |
| 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. This applies to table columns that have not had a column-specific target set via ALTER TABLE SET STATISTICS. |
| 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 | Sets the FROM-list size beyond which subqueries are not collapsed. The planner will merge subqueries into upper queries if the resulting FROM list would have no more than this many items. |
| 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 | Allow JIT compilation. |
| 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. The planner will flatten explicit JOIN constructs into lists of FROM items whenever a list of no more than this many items would result. |
| 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. Prepared statements can have custom and generic plans, and the planner will attempt to choose which is better. This can be set to override the default behavior. |
| 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 |
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 |