![]() enable_partition_pruning ( boolean)Įnables or disables the query planner's ability to eliminate a partitioned table's partitions from query plans. Has no effect if hash-join plans are not also enabled. enable_parallel_hash ( boolean)Įnables or disables the query planner's use of hash-join plan types with parallel hash. enable_parallel_append ( boolean)Įnables or disables the query planner's use of parallel-aware append plan types. It is impossible to suppress nested-loop joins entirely, but turning this variable off discourages the planner from using one if there are other methods available. enable_nestloop ( boolean)Įnables or disables the query planner's use of nested-loop join plans. enable_mergejoin ( boolean)Įnables or disables the query planner's use of merge-join plan types. Less commonly looked up results may be evicted from the cache when more space is required for new entries. This plan type allows scans to the underlying plans to be skipped when the results for the current parameters are already in the cache. enable_memoize ( boolean)Įnables or disables the query planner's use of memoize plans for caching results from parameterized scans inside nested-loop joins. It is impossible to suppress materialization entirely, but turning this variable off prevents the planner from inserting materialize nodes except in cases where it is required for correctness. enable_material ( boolean)Įnables or disables the query planner's use of materialization. enable_indexonlyscan ( boolean)Įnables or disables the query planner's use of index-only-scan plan types (see Section 11.9). ![]() enable_indexscan ( boolean)Įnables or disables the query planner's use of index-scan plan types. enable_incremental_sort ( boolean)Įnables or disables the query planner's use of incremental sort steps. enable_hashjoin ( boolean)Įnables or disables the query planner's use of hash-join plan types. enable_hashagg ( boolean)Įnables or disables the query planner's use of hashed aggregation plan types. ![]() ![]() enable_gathermerge ( boolean)Įnables or disables the query planner's use of gather merge plan types. enable_bitmapscan ( boolean)Įnables or disables the query planner's use of bitmap-scan plan types. Enables or disables the query planner's use of async-aware append plan types. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |