Server Configuration Parameter Changes from WarehousePG 6 to WarehousePG 7

WarehousePG 7 includes new server configuration parameters, and removes or updates the default values of certain server configuration parameters as described below.

New Parameters

The following new server configuration parameters are available in WarehousePG 7:

• allow_in_place_tablespaces
• archive_cleanup_command
• backend_flush_after
• bgwriter_flush_after
• checkpoint_flush_after
• cluster_name
• data_directory_mode
• debug_deadlocks
• default_table_access_method
• dtx_phase2_retry_second
• enable_gathermerge
• enable_groupingsets_hash_disk
• enable_hashagg_disk
• enable_parallel_append
• enable_parallel_hash
• enable_partition_pruning
• enable_partitionwise_aggregate
• enable_partitionwise_join
• force_parallel_mode
• gin_pending_list_limit
• gp_autovacuum_scope
• gp_detect_data_correctness
• gp_explain_jit
• gp_force_random_redistribution
• gp_gxid_prefetch_num
• gp_max_alloc_size
• gp_pause_on_restore_point_replay
• gp_quicklz_fallback
• gp_resgroup_memory_query_fixed_mem
• gp_resource_group_bypass_direct_dispatch
• gp_workfile_compression_overhead_limit
• idle_in_transaction_session_timeout
• jit
• jit_above_cost
• jit_debugging_support
• jit_dump_bitcode
• jit_expressions
• jit_inline_above_cost
• jit_optimize_above_cost
• jit_profiling_support
• jit_provider
• jit_tuple_deforming
• log_btree_build_stats
• log_replication_commands
• log_statement_sample_rate
• log_transaction_sample_rate
• max_logical_replication_workers
• max_parallel_maintenance_workers
• max_parallel_workers
• max_parallel_workers_per_gather
• max_pred_locks_per_page
• max_pred_locks_per_relation
• max_sync_workers_per_subscription
• max_wal_size
• min_parallel_index_scan_size
• min_parallel_table_scan_size
• min_wal_size
• old_snapshot_threshold
• operator_precedence_warning
• optimize_bounded_sort
• optimizer_enable_coordinator_only_queries
• optimizer_enable_dynamicindexonlyscan
• optimizer_enable_foreign_table
• optimizer_enable_motions_coordinatoronly_queries
• optimizer_enable_nljoin
• optimizer_enable_push_join_below_union_all
• optimizer_jit_above_cost
• optimizer_jit_inline_above_cost
• optimizer_jit_optimize_above_cost
• parallel_leader_participation
• parallel_setup_cost
• parallel_tuple_cost
• primary_conninfo
• primary_slot_name
• promote_trigger_file
• recovery_end_command
• recovery_min_apply_delay
• recovery_target
• recovery_target_action
• recovery_target_inclusive
• recovery_target_lsn
• recovery_target_name
• recovery_target_time
• recovery_target_timeline
• recovery_target_xid
• restore_command
• row_security
• shared_memory_type
• ssl_dh_params_file
• ssl_library
• ssl_max_protocol_version
• ssl_min_protocol_version
• ssl_passphrase_command
• ssl_passphrase_command_supports_reload
• ssl_renegotiation_limit
• syslog_sequence_numbers
• syslog_split_messages
• tcp_user_timeout
• trace_lock_oidmin
• trace_locks
• trace_lock_table
• trace_lwlocks
• trace_syncscan
• trace_userlocks
• track_commit_timestamp
• track_wal_io_timing
• vacuum_cleanup_index_scale_factor
• wal_compression
• wal_consistency_checking
• wal_debug
• wal_init_zero
• wal_keep_size
• wal_recycle
• wal_retrieve_retry_interval
• wal_writer_flush_after

Removed Parameters

The following server configuration parameters are removed in WarehousePG 7:

• checkpoint_segments
• debug_latch
• dev_opt_unsafe_truncate_in_subtransaction
• dtx_phase2_retry_count
• enable_implicit_timeformat_YYYYMMDDHH24MISS
• gp_add_column_inherits_table_setting
• gp_allow_rename_relation_without_lock
• gp_count_host_segments_using_address
• gp_eager_agg_distinct_pruning
• gp_eager_one_phase_agg
• gp_eager_preunique
• gp_enable_exchange_default_partition
• gp_enable_gpperfmon
• gp_enable_mk_sort
• gp_enable_motion_mk_sort
• gp_enable_sort_distinct
• gp_gpperfmon_send_interval
• gp_hashagg_default_nbatches
• gp_hashagg_groups_per_bucket
• gp_hashagg_streambottom
• gp_ignore_window_exclude
• gp_indexcheck_vacuum
• gp_keep_all_xlog
• gp_log_resqueue_priority_sleep_time
• gp_max_partition_level
• gp_mk_sort_check
• gp_partitioning_dynamic_selection_log
• gpperfmon_log_alert_level
• gpperfmon_port
• gp_perfmon_print_packet_info
• gp_perfmon_segment_interval
• gp_resgroup_print_operator_memory_limits
• gp_resource_group_cpu_ceiling_enforcement
• gp_resource_group_enable_recalculate_query_mem
• gp_resource_group_memory_limit
• gp_safefswritesize
• gp_sort_flags
• gp_sort_max_distinct
• gp_use_synchronize_seqscans_catalog_vacuum_full
• memory_spill_ratio
• optimizer_analyze_enable_merge_of_leaf_stats
• optimizer_enable_dml_triggers
• optimizer_enable_partial_index
• optimizer_prune_unused_columns
• password_hash_algorithm
• test_print_prefetch_joinqual
• wal_keep_segments

Changed Parameters

These server configuration parameters are changed in WarehousePG 7:

• The server configuration paramater optimizer_enable_orderedagg has a new default value of on.
• The server configuration parameter vacuum_cost_page_miss has a new default value of 2.
• The default value for the server configuration parameter gp_interconnect_address_type changed from wildcard to unicast.
• The wal_keep_segments server configuration parameter has been replaced by the wal_keep_size parameter.
• The autovacuum server configuration parameter is now enabled for all databases by default, rather than just for the template0 and template1 databases.
• The gp_autostats_mode server configuration parameter default value has been changed to none.
• The gp_default_storage_options parameter no longer supports the appendonly and appendoptimized keywords. Use the default_table_access_method parameter instead.