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 |