List of GP configuration parameters supported by gpconfig

Post date: Oct 20, 2014 1:31:40 AM

List all configuration parameters supported by gpconfig:gpconfig -l

[gpadmin@sachi scripts]$ gpconfig -l

[name: add_missing_from] [unit: None] [context: user] [vartype: bool] [min_val: None] [max_val: None]

[name: application_name] [unit: None] [context: user] [vartype: string] [min_val: None] [max_val: None]

[name: array_nulls] [unit: None] [context: user] [vartype: bool] [min_val: None] [max_val: None]

[name: authentication_timeout] [unit: s] [context: sighup] [vartype: integer] [min_val: 1] [max_val: 600]

[name: backslash_quote] [unit: None] [context: user] [vartype: string] [min_val: None] [max_val: None]

[name: block_size] [unit: ] [context: internal] [vartype: integer] [min_val: 32768] [max_val: 32768]

[name: bonjour_name] [unit: None] [context: postmaster] [vartype: string] [min_val: None] [max_val: None]

[name: check_function_bodies] [unit: None] [context: user] [vartype: bool] [min_val: None] [max_val: None]

[name: client_encoding] [unit: None] [context: user] [vartype: string] [min_val: None] [max_val: None]

[name: client_min_messages] [unit: None] [context: user] [vartype: string] [min_val: None] [max_val: None]

[name: cpu_index_tuple_cost] [unit: None] [context: user] [vartype: real] [min_val: 0] [max_val: 1.79769e+308]

[name: cpu_operator_cost] [unit: None] [context: user] [vartype: real] [min_val: 0] [max_val: 1.79769e+308]

[name: cpu_tuple_cost] [unit: None] [context: user] [vartype: real] [min_val: 0] [max_val: 1.79769e+308]

[name: cursor_tuple_fraction] [unit: None] [context: user] [vartype: real] [min_val: 0] [max_val: 1]

[name: custom_variable_classes] [unit: None] [context: sighup] [vartype: string] [min_val: None] [max_val: None]

[name: DateStyle] [unit: None] [context: user] [vartype: string] [min_val: None] [max_val: None]

[name: db_user_namespace] [unit: None] [context: sighup] [vartype: bool] [min_val: None] [max_val: None]

[name: deadlock_timeout] [unit: ms] [context: sighup] [vartype: integer] [min_val: 0] [max_val: 2147483647]

[name: debug_assertions] [unit: None] [context: user] [vartype: bool] [min_val: None] [max_val: None]

[name: debug_pretty_print] [unit: None] [context: user] [vartype: bool] [min_val: None] [max_val: None]

[name: debug_print_parse] [unit: None] [context: user] [vartype: bool] [min_val: None] [max_val: None]

[name: debug_print_plan] [unit: None] [context: user] [vartype: bool] [min_val: None] [max_val: None]

[name: debug_print_prelim_plan] [unit: None] [context: user] [vartype: bool] [min_val: None] [max_val: None]

[name: debug_print_rewritten] [unit: None] [context: user] [vartype: bool] [min_val: None] [max_val: None]

[name: debug_print_slice_table] [unit: None] [context: user] [vartype: bool] [min_val: None] [max_val: None]

[name: default_statistics_target] [unit: ] [context: user] [vartype: integer] [min_val: 1] [max_val: 1000]

[name: default_tablespace] [unit: None] [context: user] [vartype: string] [min_val: None] [max_val: None]

[name: default_transaction_isolation] [unit: None] [context: user] [vartype: string] [min_val: None] [max_val: None]

[name: default_transaction_read_only] [unit: None] [context: user] [vartype: bool] [min_val: None] [max_val: None]

[name: dynamic_library_path] [unit: None] [context: superuser] [vartype: string] [min_val: None] [max_val: None]

[name: effective_cache_size] [unit: 32kB] [context: user] [vartype: integer] [min_val: 1] [max_val: 2147483647]

[name: enable_bitmapscan] [unit: None] [context: user] [vartype: bool] [min_val: None] [max_val: None]

[name: enable_groupagg] [unit: None] [context: user] [vartype: bool] [min_val: None] [max_val: None]

[name: enable_hashagg] [unit: None] [context: user] [vartype: bool] [min_val: None] [max_val: None]

[name: enable_hashjoin] [unit: None] [context: user] [vartype: bool] [min_val: None] [max_val: None]

[name: enable_indexscan] [unit: None] [context: user] [vartype: bool] [min_val: None] [max_val: None]

[name: enable_mergejoin] [unit: None] [context: user] [vartype: bool] [min_val: None] [max_val: None]

[name: enable_nestloop] [unit: None] [context: user] [vartype: bool] [min_val: None] [max_val: None]

[name: enable_seqscan] [unit: None] [context: user] [vartype: bool] [min_val: None] [max_val: None]

[name: enable_sort] [unit: None] [context: user] [vartype: bool] [min_val: None] [max_val: None]

[name: enable_tidscan] [unit: None] [context: user] [vartype: bool] [min_val: None] [max_val: None]

[name: escape_string_warning] [unit: None] [context: user] [vartype: bool] [min_val: None] [max_val: None]

[name: explain_pretty_print] [unit: None] [context: user] [vartype: bool] [min_val: None] [max_val: None]

[name: extra_float_digits] [unit: ] [context: user] [vartype: integer] [min_val: -15] [max_val: 2]

[name: from_collapse_limit] [unit: ] [context: user] [vartype: integer] [min_val: 1] [max_val: 2147483647]

[name: gp_adjust_selectivity_for_outerjoins] [unit: None] [context: user] [vartype: bool] [min_val: None] [max_val: None]

[name: gp_analyze_relative_error] [unit: None] [context: user] [vartype: real] [min_val: 0] [max_val: 1]

[name: gp_autostats_mode] [unit: None] [context: user] [vartype: string] [min_val: None] [max_val: None]

[name: gp_autostats_on_change_threshold] [unit: ] [context: user] [vartype: integer] [min_val: 0] [max_val: 2147483647]

[name: gp_backup_directIO] [unit: None] [context: user] [vartype: bool] [min_val: None] [max_val: None]

[name: gp_backup_directIO_read_chunk_mb] [unit: ] [context: user] [vartype: integer] [min_val: 1] [max_val: 200]

[name: gp_cached_segworkers_threshold] [unit: ] [context: user] [vartype: integer] [min_val: 0] [max_val: 2147483647]

[name: gp_command_count] [unit: ] [context: internal] [vartype: integer] [min_val: 0] [max_val: 2147483647]

[name: gp_connectemc_mode] [unit: None] [context: postmaster] [vartype: string] [min_val: None] [max_val: None]

[name: gp_connections_per_thread] [unit: ] [context: superuser] [vartype: integer] [min_val: 0] [max_val: 2147483647]

[name: gp_contentid] [unit: ] [context: postmaster] [vartype: integer] [min_val: -2147483648] [max_val: 2147483647]

[name: gp_dbid] [unit: ] [context: postmaster] [vartype: integer] [min_val: -2147483648] [max_val: 2147483647]

[name: gp_debug_linger] [unit: s] [context: user] [vartype: integer] [min_val: 0] [max_val: 3600]

[name: gp_dynamic_partition_pruning] [unit: None] [context: user] [vartype: bool] [min_val: None] [max_val: None]

[name: gp_email_connect_avoid_duration] [unit: ] [context: superuser] [vartype: integer] [min_val: 300] [max_val: 86400]

[name: gp_email_connect_failures] [unit: ] [context: superuser] [vartype: integer] [min_val: 3] [max_val: 100]

[name: gp_email_connect_timeout] [unit: ] [context: superuser] [vartype: integer] [min_val: 10] [max_val: 120]

[name: gp_email_from] [unit: None] [context: superuser] [vartype: string] [min_val: None] [max_val: None]

[name: gp_email_smtp_password] [unit: None] [context: superuser] [vartype: string] [min_val: None] [max_val: None]

[name: gp_email_smtp_server] [unit: None] [context: superuser] [vartype: string] [min_val: None] [max_val: None]

[name: gp_email_smtp_userid] [unit: None] [context: superuser] [vartype: string] [min_val: None] [max_val: None]

[name: gp_email_to] [unit: None] [context: superuser] [vartype: string] [min_val: None] [max_val: None]

[name: gp_enable_adaptive_nestloop] [unit: None] [context: user] [vartype: bool] [min_val: None] [max_val: None]

[name: gp_enable_agg_distinct] [unit: None] [context: user] [vartype: bool] [min_val: None] [max_val: None]

[name: gp_enable_agg_distinct_pruning] [unit: None] [context: user] [vartype: bool] [min_val: None] [max_val: None]

[name: gp_enable_direct_dispatch] [unit: None] [context: user] [vartype: bool] [min_val: None] [max_val: None]

[name: gp_enable_fallback_plan] [unit: None] [context: user] [vartype: bool] [min_val: None] [max_val: None]

[name: gp_enable_fast_sri] [unit: None] [context: user] [vartype: bool] [min_val: None] [max_val: None]

[name: gp_enable_gpperfmon] [unit: None] [context: postmaster] [vartype: bool] [min_val: None] [max_val: None]

[name: gp_enable_groupext_distinct_gather] [unit: None] [context: user] [vartype: bool] [min_val: None] [max_val: None]

[name: gp_enable_groupext_distinct_pruning] [unit: None] [context: user] [vartype: bool] [min_val: None] [max_val: None]

[name: gp_enable_multiphase_agg] [unit: None] [context: user] [vartype: bool] [min_val: None] [max_val: None]

[name: gp_enable_predicate_propagation] [unit: None] [context: user] [vartype: bool] [min_val: None] [max_val: None]

[name: gp_enable_preunique] [unit: None] [context: user] [vartype: bool] [min_val: None] [max_val: None]

[name: gp_enable_sequential_window_plans] [unit: None] [context: user] [vartype: bool] [min_val: None] [max_val: None]

[name: gp_enable_sort_distinct] [unit: None] [context: user] [vartype: bool] [min_val: None] [max_val: None]

[name: gp_enable_sort_limit] [unit: None] [context: user] [vartype: bool] [min_val: None] [max_val: None]

[name: gp_external_enable_exec] [unit: None] [context: postmaster] [vartype: bool] [min_val: None] [max_val: None]

[name: gp_external_grant_privileges] [unit: None] [context: postmaster] [vartype: bool] [min_val: None] [max_val: None]

[name: gp_external_max_segs] [unit: ] [context: user] [vartype: integer] [min_val: 1] [max_val: 2147483647]

[name: gp_filerep_tcp_keepalives_count] [unit: ] [context: user] [vartype: integer] [min_val: 0] [max_val: 2147483647]

[name: gp_filerep_tcp_keepalives_idle] [unit: s] [context: user] [vartype: integer] [min_val: 0] [max_val: 2147483647]

[name: gp_filerep_tcp_keepalives_interval] [unit: s] [context: user] [vartype: integer] [min_val: 0] [max_val: 2147483647]

[name: gp_fts_probe_interval] [unit: s] [context: postmaster] [vartype: integer] [min_val: 10] [max_val: 2147483647]

[name: gp_fts_probe_threadcount] [unit: ] [context: postmaster] [vartype: integer] [min_val: 1] [max_val: 128]

[name: gp_fts_probe_timeout] [unit: s] [context: user] [vartype: integer] [min_val: 0] [max_val: 2147483647]

[name: gp_gpperfmon_send_interval] [unit: ] [context: user] [vartype: integer] [min_val: 1] [max_val: 3600]

[name: gp_hadoop_home] [unit: None] [context: user] [vartype: string] [min_val: None] [max_val: None]

[name: gp_hadoop_target_version] [unit: None] [context: user] [vartype: string] [min_val: None] [max_val: None]

[name: gp_hashjoin_tuples_per_bucket] [unit: ] [context: user] [vartype: integer] [min_val: 1] [max_val: 25]

[name: gp_idf_deduplicate] [unit: None] [context: user] [vartype: string] [min_val: None] [max_val: None]

[name: gp_interconnect_hash_multiplier] [unit: ] [context: superuser] [vartype: integer] [min_val: 1] [max_val: 256]

[name: gp_interconnect_queue_depth] [unit: ] [context: user] [vartype: integer] [min_val: 1] [max_val: 4096]

[name: gp_interconnect_setup_timeout] [unit: s] [context: user] [vartype: integer] [min_val: 0] [max_val: 7200]

[name: gp_interconnect_type] [unit: None] [context: user] [vartype: string] [min_val: None] [max_val: None]

[name: gp_log_format] [unit: None] [context: postmaster] [vartype: string] [min_val: None] [max_val: None]

[name: gp_max_csv_line_length] [unit: ] [context: user] [vartype: integer] [min_val: 32768] [max_val: 4194304]

[name: gp_max_databases] [unit: ] [context: postmaster] [vartype: integer] [min_val: 8] [max_val: 256]

[name: gp_max_filespaces] [unit: ] [context: postmaster] [vartype: integer] [min_val: 8] [max_val: 256]

[name: gp_max_local_distributed_cache] [unit: ] [context: postmaster] [vartype: integer] [min_val: 0] [max_val: 2147483647]

[name: gp_max_packet_size] [unit: ] [context: backend] [vartype: integer] [min_val: 512] [max_val: 65507]

[name: gp_max_tablespaces] [unit: ] [context: postmaster] [vartype: integer] [min_val: 8] [max_val: 2048]

[name: gp_motion_cost_per_row] [unit: None] [context: user] [vartype: real] [min_val: 0] [max_val: 1.79769e+308]

[name: gp_num_contents_in_cluster] [unit: ] [context: postmaster] [vartype: integer] [min_val: -2147483648] [max_val: 2147483647]

[name: gp_reject_percent_threshold] [unit: ] [context: user] [vartype: integer] [min_val: 0] [max_val: 2147483647]

[name: gp_reraise_signal] [unit: None] [context: superuser] [vartype: bool] [min_val: None] [max_val: None]

[name: gp_resqueue_memory_policy] [unit: None] [context: superuser] [vartype: string] [min_val: None] [max_val: None]

[name: gp_resqueue_priority] [unit: None] [context: postmaster] [vartype: bool] [min_val: None] [max_val: None]

[name: gp_resqueue_priority_cpucores_per_segment] [unit: None] [context: postmaster] [vartype: real] [min_val: 0.1] [max_val: 25]

[name: gp_resqueue_priority_sweeper_interval] [unit: ] [context: postmaster] [vartype: integer] [min_val: 500] [max_val: 15000]

[name: gp_role] [unit: None] [context: superuser] [vartype: string] [min_val: None] [max_val: None]

[name: gp_safefswritesize] [unit: ] [context: backend] [vartype: integer] [min_val: 0] [max_val: 2147483647]

[name: gp_segment_connect_timeout] [unit: s] [context: user] [vartype: integer] [min_val: 0] [max_val: 2147483647]

[name: gp_segments_for_planner] [unit: ] [context: user] [vartype: integer] [min_val: 0] [max_val: 2147483647]

[name: gp_session_id] [unit: ] [context: backend] [vartype: integer] [min_val: -2147483648] [max_val: 2147483647]

[name: gp_set_proc_affinity] [unit: None] [context: postmaster] [vartype: bool] [min_val: None] [max_val: None]

[name: gp_snmp_community] [unit: None] [context: superuser] [vartype: string] [min_val: None] [max_val: None]

[name: gp_snmp_monitor_address] [unit: None] [context: superuser] [vartype: string] [min_val: None] [max_val: None]

[name: gp_snmp_use_inform_or_trap] [unit: None] [context: superuser] [vartype: string] [min_val: None] [max_val: None]

[name: gp_standby_dbid] [unit: ] [context: postmaster] [vartype: integer] [min_val: -2147483648] [max_val: 32767]

[name: gp_statistics_pullup_from_child_partition] [unit: None] [context: user] [vartype: bool] [min_val: None] [max_val: None]

[name: gp_statistics_use_fkeys] [unit: None] [context: user] [vartype: bool] [min_val: None] [max_val: None]

[name: gp_subtrans_warn_limit] [unit: ] [context: postmaster] [vartype: integer] [min_val: 0] [max_val: 2147483647]

[name: gp_vmem_idle_resource_timeout] [unit: ms] [context: user] [vartype: integer] [min_val: 0] [max_val: 2147483647]

[name: gp_vmem_protect_limit] [unit: ] [context: postmaster] [vartype: integer] [min_val: 0] [max_val: 1073741823]

[name: gp_vmem_protect_segworker_cache_limit] [unit: ] [context: postmaster] [vartype: integer] [min_val: 1] [max_val: 1073741823]

[name: gp_workfile_checksumming] [unit: None] [context: user] [vartype: bool] [min_val: None] [max_val: None]

[name: gp_workfile_compress_algorithm] [unit: None] [context: user] [vartype: string] [min_val: None] [max_val: None]

[name: gpperfmon_port] [unit: ] [context: postmaster] [vartype: integer] [min_val: 1024] [max_val: 65535]

[name: integer_datetimes] [unit: None] [context: internal] [vartype: bool] [min_val: None] [max_val: None]

[name: IntervalStyle] [unit: None] [context: user] [vartype: string] [min_val: None] [max_val: None]

[name: join_collapse_limit] [unit: ] [context: user] [vartype: integer] [min_val: 1] [max_val: 2147483647]

[name: krb_caseins_users] [unit: None] [context: postmaster] [vartype: bool] [min_val: None] [max_val: None]

[name: krb_server_keyfile] [unit: None] [context: sighup] [vartype: string] [min_val: None] [max_val: None]

[name: krb_srvname] [unit: None] [context: sighup] [vartype: string] [min_val: None] [max_val: None]

[name: lc_collate] [unit: None] [context: internal] [vartype: string] [min_val: None] [max_val: None]

[name: lc_ctype] [unit: None] [context: internal] [vartype: string] [min_val: None] [max_val: None]

[name: lc_messages] [unit: None] [context: superuser] [vartype: string] [min_val: None] [max_val: None]

[name: lc_monetary] [unit: None] [context: user] [vartype: string] [min_val: None] [max_val: None]

[name: lc_numeric] [unit: None] [context: user] [vartype: string] [min_val: None] [max_val: None]

[name: lc_time] [unit: None] [context: user] [vartype: string] [min_val: None] [max_val: None]

[name: local_preload_libraries] [unit: None] [context: backend] [vartype: string] [min_val: None] [max_val: None]

[name: log_autostats] [unit: None] [context: superuser] [vartype: bool] [min_val: None] [max_val: None]

[name: log_connections] [unit: None] [context: backend] [vartype: bool] [min_val: None] [max_val: None]

[name: log_disconnections] [unit: None] [context: backend] [vartype: bool] [min_val: None] [max_val: None]

[name: log_dispatch_stats] [unit: None] [context: superuser] [vartype: bool] [min_val: None] [max_val: None]

[name: log_duration] [unit: None] [context: superuser] [vartype: bool] [min_val: None] [max_val: None]

[name: log_error_verbosity] [unit: None] [context: superuser] [vartype: string] [min_val: None] [max_val: None]

[name: log_executor_stats] [unit: None] [context: superuser] [vartype: bool] [min_val: None] [max_val: None]

[name: log_hostname] [unit: None] [context: sighup] [vartype: bool] [min_val: None] [max_val: None]

[name: log_min_duration_statement] [unit: ms] [context: superuser] [vartype: integer] [min_val: -1] [max_val: 2147483]

[name: log_min_error_statement] [unit: None] [context: superuser] [vartype: string] [min_val: None] [max_val: None]

[name: log_min_messages] [unit: None] [context: superuser] [vartype: string] [min_val: None] [max_val: None]

[name: log_parser_stats] [unit: None] [context: superuser] [vartype: bool] [min_val: None] [max_val: None]

[name: log_planner_stats] [unit: None] [context: superuser] [vartype: bool] [min_val: None] [max_val: None]

[name: log_rotation_age] [unit: min] [context: sighup] [vartype: integer] [min_val: 0] [max_val: 35791394]

[name: log_rotation_size] [unit: kB] [context: sighup] [vartype: integer] [min_val: 0] [max_val: 2097151]

[name: log_statement] [unit: None] [context: superuser] [vartype: string] [min_val: None] [max_val: None]

[name: log_statement_stats] [unit: None] [context: superuser] [vartype: bool] [min_val: None] [max_val: None]

[name: log_timezone] [unit: None] [context: sighup] [vartype: string] [min_val: None] [max_val: None]

[name: log_truncate_on_rotation] [unit: None] [context: sighup] [vartype: bool] [min_val: None] [max_val: None]

[name: maintenance_work_mem] [unit: kB] [context: user] [vartype: integer] [min_val: 1024] [max_val: 2147483647]

[name: max_appendonly_tables] [unit: ] [context: postmaster] [vartype: integer] [min_val: 0] [max_val: 2147483647]

[name: max_connections] [unit: ] [context: postmaster] [vartype: integer] [min_val: 10] [max_val: 65535]

[name: max_files_per_process] [unit: ] [context: postmaster] [vartype: integer] [min_val: 25] [max_val: 2147483647]

[name: max_fsm_pages] [unit: ] [context: postmaster] [vartype: integer] [min_val: 1000] [max_val: 2147483647]

[name: max_fsm_relations] [unit: ] [context: postmaster] [vartype: integer] [min_val: 100] [max_val: 2147483647]

[name: max_function_args] [unit: ] [context: internal] [vartype: integer] [min_val: 100] [max_val: 100]

[name: max_identifier_length] [unit: ] [context: internal] [vartype: integer] [min_val: 63] [max_val: 63]

[name: max_index_keys] [unit: ] [context: internal] [vartype: integer] [min_val: 32] [max_val: 32]

[name: max_locks_per_transaction] [unit: ] [context: postmaster] [vartype: integer] [min_val: 10] [max_val: 2147483647]

[name: max_prepared_transactions] [unit: ] [context: postmaster] [vartype: integer] [min_val: 0] [max_val: 1000]

[name: max_resource_portals_per_transaction] [unit: ] [context: postmaster] [vartype: integer] [min_val: 0] [max_val: 2147483647]

[name: max_resource_queues] [unit: ] [context: postmaster] [vartype: integer] [min_val: 0] [max_val: 2147483647]

[name: max_stack_depth] [unit: kB] [context: superuser] [vartype: integer] [min_val: 100] [max_val: 2147483647]

[name: max_statement_mem] [unit: kB] [context: superuser] [vartype: integer] [min_val: 32768] [max_val: 2147483647]

[name: max_work_mem] [unit: kB] [context: superuser] [vartype: integer] [min_val: 256] [max_val: 2147483647]

[name: password_encryption] [unit: None] [context: user] [vartype: bool] [min_val: None] [max_val: None]

[name: password_hash_algorithm] [unit: None] [context: superuser] [vartype: string] [min_val: None] [max_val: None]

[name: pljava_classpath] [unit: None] [context: user] [vartype: string] [min_val: None] [max_val: None]

[name: pljava_release_lingering_savepoints] [unit: None] [context: superuser] [vartype: bool] [min_val: None] [max_val: None]

[name: pljava_statement_cache_size] [unit: ] [context: superuser] [vartype: integer] [min_val: 0] [max_val: 512]

[name: pljava_vmoptions] [unit: None] [context: superuser] [vartype: string] [min_val: None] [max_val: None]

[name: random_page_cost] [unit: None] [context: user] [vartype: real] [min_val: 0] [max_val: 1.79769e+308]

[name: regex_flavor] [unit: None] [context: user] [vartype: string] [min_val: None] [max_val: None]

[name: resource_cleanup_gangs_on_wait] [unit: None] [context: user] [vartype: bool] [min_val: None] [max_val: None]

[name: resource_select_only] [unit: None] [context: postmaster] [vartype: bool] [min_val: None] [max_val: None]

[name: search_path] [unit: None] [context: user] [vartype: string] [min_val: None] [max_val: None]

[name: seq_page_cost] [unit: None] [context: user] [vartype: real] [min_val: 0] [max_val: 1.79769e+308]

[name: server_encoding] [unit: None] [context: internal] [vartype: string] [min_val: None] [max_val: None]

[name: server_version] [unit: None] [context: internal] [vartype: string] [min_val: None] [max_val: None]

[name: server_version_num] [unit: ] [context: internal] [vartype: integer] [min_val: 80215] [max_val: 80215]

[name: shared_buffers] [unit: 32kB] [context: postmaster] [vartype: integer] [min_val: 16] [max_val: 1073741823]

[name: shared_preload_libraries] [unit: None] [context: postmaster] [vartype: string] [min_val: None] [max_val: None]

[name: ssl] [unit: None] [context: postmaster] [vartype: bool] [min_val: None] [max_val: None]

[name: ssl_ciphers] [unit: None] [context: postmaster] [vartype: string] [min_val: None] [max_val: None]

[name: standard_conforming_strings] [unit: None] [context: user] [vartype: bool] [min_val: None] [max_val: None]

[name: statement_mem] [unit: kB] [context: user] [vartype: integer] [min_val: 1000] [max_val: 2147483647]

[name: statement_timeout] [unit: ms] [context: user] [vartype: integer] [min_val: 0] [max_val: 2147483647]

[name: stats_queue_level] [unit: None] [context: superuser] [vartype: bool] [min_val: None] [max_val: None]

[name: superuser_reserved_connections] [unit: ] [context: postmaster] [vartype: integer] [min_val: 0] [max_val: 536870911]

[name: tcp_keepalives_count] [unit: ] [context: user] [vartype: integer] [min_val: 0] [max_val: 2147483647]

[name: tcp_keepalives_idle] [unit: s] [context: user] [vartype: integer] [min_val: 0] [max_val: 2147483647]

[name: tcp_keepalives_interval] [unit: s] [context: user] [vartype: integer] [min_val: 0] [max_val: 2147483647]

[name: temp_buffers] [unit: 32kB] [context: user] [vartype: integer] [min_val: 100] [max_val: 1073741823]

[name: TimeZone] [unit: None] [context: user] [vartype: string] [min_val: None] [max_val: None]

[name: timezone_abbreviations] [unit: None] [context: user] [vartype: string] [min_val: None] [max_val: None]

[name: track_activities] [unit: None] [context: superuser] [vartype: bool] [min_val: None] [max_val: None]

[name: track_counts] [unit: None] [context: superuser] [vartype: bool] [min_val: None] [max_val: None]

[name: transaction_isolation] [unit: None] [context: user] [vartype: string] [min_val: None] [max_val: None]

[name: transaction_read_only] [unit: None] [context: user] [vartype: bool] [min_val: None] [max_val: None]

[name: transform_null_equals] [unit: None] [context: user] [vartype: bool] [min_val: None] [max_val: None]

[name: unix_socket_directory] [unit: None] [context: postmaster] [vartype: string] [min_val: None] [max_val: None]

[name: unix_socket_group] [unit: None] [context: postmaster] [vartype: string] [min_val: None] [max_val: None]

[name: unix_socket_permissions] [unit: ] [context: postmaster] [vartype: integer] [min_val: 0] [max_val: 511]

[name: update_process_title] [unit: None] [context: superuser] [vartype: bool] [min_val: None] [max_val: None]

[name: vacuum_cost_delay] [unit: ms] [context: user] [vartype: integer] [min_val: 0] [max_val: 1000]

[name: vacuum_cost_limit] [unit: ] [context: user] [vartype: integer] [min_val: 1] [max_val: 10000]

[name: vacuum_cost_page_dirty] [unit: ] [context: user] [vartype: integer] [min_val: 0] [max_val: 10000]

[name: vacuum_cost_page_hit] [unit: ] [context: user] [vartype: integer] [min_val: 0] [max_val: 10000]

[name: vacuum_cost_page_miss] [unit: ] [context: user] [vartype: integer] [min_val: 0] [max_val: 10000]

[name: vacuum_freeze_min_age] [unit: ] [context: user] [vartype: integer] [min_val: 0] [max_val: 1000000000]

[name: work_mem] [unit: kB] [context: user] [vartype: integer] [min_val: 256] [max_val: 2147483647]

[gpadmin@sachi scripts]$