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 haven't 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 aren't 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 aren't 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 |