Query Tuning / Planner Method Configuration
enable_async_append
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of async append plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | enable_async_append |
enable_bitmapscan
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of bitmap-scan plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_bitmapscan |
enable_gathermerge
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of gather merge plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_gathermerge |
enable_hashagg
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of hashed aggregation plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_hashagg |
enable_hashjoin
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of hash join plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_hashjoin |
enable_incremental_sort
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of incremental sort steps. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | enable_incremental_sort |
enable_indexonlyscan
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of index-only-scan plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_indexonlyscan |
enable_indexscan
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of index-scan plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_indexscan |
enable_material
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of materialization. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_material |
enable_memoize
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of memoization. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | enable_memoize |
enable_mergejoin
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of merge join plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_mergejoin |
enable_nestloop
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of nested loop join plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_nestloop |
enable_parallel_append
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of parallel append plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | enable_parallel_append |
enable_parallel_hash
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of parallel hash plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | enable_parallel_hash |
enable_partition_pruning
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables plan-time and execution-time partition pruning. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | enable_partition_pruning |
enable_partitionwise_aggregate
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables or disables the query planner's use of partitionwise grouping or aggregation, which allows grouping or aggregation on a partitioned tables performed separately for each partition. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_partitionwise_aggregate |
enable_partitionwise_join
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables or disables the query planner's use of partitionwise join, which allows a join between partitioned tables to be performed by joining the matching partitions. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_partitionwise_join |
enable_seqscan
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of sequential-scan plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_seqscan |
enable_sort
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of explicit sort steps. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_sort |
enable_tidscan
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of TID scan plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_tidscan |
enable_async_append
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of async append plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | enable_async_append |
enable_bitmapscan
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of bitmap-scan plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_bitmapscan |
enable_gathermerge
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of gather merge plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_gathermerge |
enable_hashagg
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of hashed aggregation plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_hashagg |
enable_hashjoin
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of hash join plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_hashjoin |
enable_incremental_sort
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of incremental sort steps. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | enable_incremental_sort |
enable_indexonlyscan
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of index-only-scan plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_indexonlyscan |
enable_indexscan
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of index-scan plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_indexscan |
enable_material
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of materialization. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_material |
enable_memoize
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of memoization. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | enable_memoize |
enable_mergejoin
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of merge join plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_mergejoin |
enable_nestloop
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of nested loop join plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_nestloop |
enable_parallel_append
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of parallel append plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | enable_parallel_append |
enable_parallel_hash
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of parallel hash plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | enable_parallel_hash |
enable_partition_pruning
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables plan-time and execution-time partition pruning. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | enable_partition_pruning |
enable_partitionwise_aggregate
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables or disables the query planner's use of partitionwise grouping or aggregation, which allows grouping or aggregation on a partitioned tables performed separately for each partition. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_partitionwise_aggregate |
enable_partitionwise_join
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables or disables the query planner's use of partitionwise join, which allows a join between partitioned tables to be performed by joining the matching partitions. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_partitionwise_join |
enable_seqscan
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of sequential-scan plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_seqscan |
enable_sort
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of explicit sort steps. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_sort |
enable_tidscan
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of TID scan plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_tidscan |
enable_async_append
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of async append plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | enable_async_append |
enable_bitmapscan
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of bitmap-scan plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_bitmapscan |
enable_gathermerge
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of gather merge plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_gathermerge |
enable_hashagg
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of hashed aggregation plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_hashagg |
enable_hashjoin
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of hash join plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_hashjoin |
enable_incremental_sort
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of incremental sort steps. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | enable_incremental_sort |
enable_indexonlyscan
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of index-only-scan plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_indexonlyscan |
enable_indexscan
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of index-scan plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_indexscan |
enable_material
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of materialization. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_material |
enable_memoize
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of memoization. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | enable_memoize |
enable_mergejoin
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of merge join plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_mergejoin |
enable_nestloop
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of nested loop join plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_nestloop |
enable_parallel_append
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of parallel append plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | enable_parallel_append |
enable_parallel_hash
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of parallel hash plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | enable_parallel_hash |
enable_partition_pruning
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables plan-time and execution-time partition pruning. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | enable_partition_pruning |
enable_partitionwise_aggregate
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables or disables the query planner's use of partitionwise grouping or aggregation, which allows grouping or aggregation on a partitioned tables performed separately for each partition. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_partitionwise_aggregate |
enable_partitionwise_join
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables or disables the query planner's use of partitionwise join, which allows a join between partitioned tables to be performed by joining the matching partitions. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_partitionwise_join |
enable_seqscan
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of sequential-scan plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_seqscan |
enable_sort
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of explicit sort steps. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_sort |
enable_tidscan
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of TID scan plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_tidscan |
enable_bitmapscan
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of bitmap-scan plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_bitmapscan |
enable_gathermerge
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of gather merge plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_gathermerge |
enable_hashagg
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of hashed aggregation plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_hashagg |
enable_hashjoin
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of hash join plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_hashjoin |
enable_incremental_sort
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of incremental sort steps. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | enable_incremental_sort |
enable_indexonlyscan
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of index-only-scan plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_indexonlyscan |
enable_indexscan
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of index-scan plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_indexscan |
enable_material
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of materialization. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_material |
enable_mergejoin
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of merge join plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_mergejoin |
enable_nestloop
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of nested loop join plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_nestloop |
enable_parallel_append
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of parallel append plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | enable_parallel_append |
enable_parallel_hash
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of parallel hash plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | enable_parallel_hash |
enable_partition_pruning
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables plan-time and run-time partition pruning. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | enable_partition_pruning |
enable_partitionwise_aggregate
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables or disables the query planner's use of partitionwise grouping or aggregation, which allows grouping or aggregation on a partitioned tables performed separately for each partition. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_partitionwise_aggregate |
enable_partitionwise_join
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables or disables the query planner's use of partitionwise join, which allows a join between partitioned tables to be performed by joining the matching partitions. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_partitionwise_join |
enable_seqscan
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of sequential-scan plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_seqscan |
enable_sort
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of explicit sort steps. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_sort |
enable_tidscan
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of TID scan plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_tidscan |
enable_bitmapscan
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of bitmap-scan plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_bitmapscan |
enable_gathermerge
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of gather merge plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_gathermerge |
enable_hashagg
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of hashed aggregation plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_hashagg |
enable_hashjoin
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of hash join plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_hashjoin |
enable_indexonlyscan
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of index-only-scan plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_indexonlyscan |
enable_indexscan
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of index-scan plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_indexscan |
enable_material
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of materialization. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_material |
enable_mergejoin
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of merge join plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_mergejoin |
enable_nestloop
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of nested loop join plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_nestloop |
enable_parallel_append
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of parallel append plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | enable_parallel_append |
enable_parallel_hash
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of parallel hash plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | enable_parallel_hash |
enable_partition_pruning
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables plan-time and run-time partition pruning. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | enable_partition_pruning |
enable_partitionwise_aggregate
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables or disables the query planner's use of partitionwise grouping or aggregation, which allows grouping or aggregation on a partitioned tables performed separately for each partition. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_partitionwise_aggregate |
enable_partitionwise_join
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables or disables the query planner's use of partitionwise join, which allows a join between partitioned tables to be performed by joining the matching partitions. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_partitionwise_join |
enable_seqscan
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of sequential-scan plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_seqscan |
enable_sort
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of explicit sort steps. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_sort |
enable_tidscan
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of TID scan plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_tidscan |
enable_bitmapscan
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of bitmap-scan plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_bitmapscan |
enable_gathermerge
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of gather merge plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_gathermerge |
enable_hashagg
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of hashed aggregation plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_hashagg |
enable_hashjoin
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of hash join plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_hashjoin |
enable_indexonlyscan
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of index-only-scan plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_indexonlyscan |
enable_indexscan
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of index-scan plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_indexscan |
enable_material
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of materialization. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_material |
enable_mergejoin
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of merge join plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_mergejoin |
enable_nestloop
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of nested loop join plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_nestloop |
enable_parallel_append
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of parallel append plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | enable_parallel_append |
enable_parallel_hash
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of parallel hash plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | enable_parallel_hash |
enable_partition_pruning
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enable plan-time and run-time partition pruning. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | enable_partition_pruning |
enable_partitionwise_aggregate
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables or disables the query planner's use of partitionwise grouping or aggregation, which allows grouping or aggregation on a partitioned tables performed separately for each partition. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_partitionwise_aggregate |
enable_partitionwise_join
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables or disables the query planner's use of partitionwise join, which allows a join between partitioned tables to be performed by joining the matching partitions. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_partitionwise_join |
enable_seqscan
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of sequential-scan plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_seqscan |
enable_sort
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of explicit sort steps. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_sort |
enable_tidscan
| Attribute | Value |
|---|---|
| Category | Query Tuning / Planner Method Configuration |
| Description | Enables the planner's use of TID scan plans. |
| Data type | boolean |
| Default value | on |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | enable_tidscan |
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for