From 8f340363b55d8705edbcd03d83d01a10d8828763 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Mon, 9 Oct 2023 03:00:13 +0000 Subject: [PATCH] Transaction isolation is now configured to be serializable There are also new settings for PG 15, but it's too much of a hassle to break these into a separate commit. Especially since there's no production data yet. --- db/pg_settings | 774 ++++++++++++++++++++++++++----------------------- 1 file changed, 409 insertions(+), 365 deletions(-) diff --git a/db/pg_settings b/db/pg_settings index ac99024..af8d149 100644 --- a/db/pg_settings +++ b/db/pg_settings @@ -1,366 +1,410 @@ - DateStyle | ISO, MDY | | f - IntervalStyle | postgres | | f - TimeZone | UCT | | f - allow_in_place_tablespaces | off | | f - allow_system_table_mods | off | | f - application_name | psql | | f - archive_cleanup_command | | | f - archive_command | BlobLogUpload.sh %f %p | | f - archive_library | | | f - archive_mode | always | | f - archive_timeout | 300 | s | f - array_nulls | on | | f - authentication_timeout | 30 | s | f - autovacuum | on | | f - autovacuum_analyze_scale_factor | 0.1 | | f - autovacuum_analyze_threshold | 50 | | f - autovacuum_freeze_max_age | 200000000 | | f - autovacuum_max_workers | 3 | | f - autovacuum_multixact_freeze_max_age | 400000000 | | f - autovacuum_naptime | 60 | s | f - autovacuum_vacuum_cost_delay | 2 | ms | f - autovacuum_vacuum_cost_limit | -1 | | f - autovacuum_vacuum_insert_scale_factor | 0.2 | | f - autovacuum_vacuum_insert_threshold | 1000 | | f - autovacuum_vacuum_scale_factor | 0.2 | | f - autovacuum_vacuum_threshold | 50 | | f - autovacuum_work_mem | -1 | kB | f - azure.accepted_password_auth_method | md5 | | f - azure.allowed_error_codes | | | f - azure.crash_active_hotstandby_on_conflict_parameter | on | | f - azure.custom_path | /datadrive/pg/data | | f - azure.customer_resource_group | DBResources | | f - azure.customer_subscription_id | 94cd8cb7-d645-497b-b140-b281f40a5c96 | | f - azure.enable_is_db_alive | on | | f - azure.enable_temp_tablespaces_on_local_ssd | on | | f - azure.enforce_ha_quorom | off | | f - azure.extensions | | | f - azure.single_to_flex_migration | off | | f - azure.threat_protection_app_type_name | PostgreSQL.Flexible | | f - azure.waittime_is_db_alive | 10000 | | f - backend_flush_after | 256 | 8kB | f - backslash_quote | safe_encoding | | f - backtrace_functions | | | f - bgwriter_delay | 20 | ms | f - bgwriter_flush_after | 64 | 8kB | f - bgwriter_lru_maxpages | 100 | | f - bgwriter_lru_multiplier | 2 | | f - block_size | 8192 | | f - bonjour | off | | f - bonjour_name | | | f - bytea_output | hex | | f - check_function_bodies | on | | f - checkpoint_completion_target | 0.9 | | f - checkpoint_flush_after | 32 | 8kB | f - checkpoint_timeout | 600 | s | f - checkpoint_warning | 30 | s | f - client_connection_check_interval | 0 | ms | f - client_encoding | UTF8 | | f - client_min_messages | notice | | f - cluster_name | | | f - commit_delay | 0 | | f - commit_siblings | 5 | | f - compute_query_id | auto | | f - constraint_exclusion | partition | | f - cpu_index_tuple_cost | 0.005 | | f - cpu_operator_cost | 0.0025 | | f - cpu_tuple_cost | 0.01 | | f - cursor_tuple_fraction | 0.1 | | f - data_checksums | on | | f - data_directory_mode | 0700 | | f - data_sync_retry | off | | f - db_user_namespace | off | | f - deadlock_timeout | 1000 | ms | f - debug_assertions | off | | f - debug_discard_caches | 0 | | f - debug_pretty_print | on | | f - debug_print_parse | off | | f - debug_print_plan | off | | f - debug_print_rewritten | off | | f - default_statistics_target | 100 | | f - default_table_access_method | heap | | f - default_tablespace | | | f - default_text_search_config | pg_catalog.english | | f - default_toast_compression | pglz | | f - default_transaction_deferrable | off | | f - default_transaction_isolation | read committed | | f - default_transaction_read_only | off | | f - dynamic_shared_memory_type | posix | | f - effective_cache_size | 786432 | 8kB | f - effective_io_concurrency | 1 | | f - enable_async_append | on | | f - enable_bitmapscan | on | | f - enable_gathermerge | on | | f - enable_hashagg | on | | f - enable_hashjoin | on | | f - enable_incremental_sort | on | | f - enable_indexonlyscan | on | | f - enable_indexscan | on | | f - enable_material | on | | f - enable_memoize | on | | f - enable_mergejoin | on | | f - enable_nestloop | on | | f - enable_parallel_append | on | | f - enable_parallel_hash | on | | f - enable_partition_pruning | on | | f - enable_partitionwise_aggregate | off | | f - enable_partitionwise_join | off | | f - enable_seqscan | on | | f - enable_sort | on | | f - enable_tidscan | on | | f - escape_string_warning | on | | f - event_source | PostgreSQL | | f - exit_on_error | off | | f - extra_float_digits | 1 | | f - force_parallel_mode | off | | f - from_collapse_limit | 8 | | f - fsync | on | | f - full_page_writes | on | | f - geqo | on | | f - geqo_effort | 5 | | f - geqo_generations | 0 | | f - geqo_pool_size | 0 | | f - geqo_seed | 0 | | f - geqo_selection_bias | 2 | | f - geqo_threshold | 12 | | f - gin_fuzzy_search_limit | 0 | | f - gin_pending_list_limit | 4096 | kB | f - hash_mem_multiplier | 2 | | f - hot_standby | on | | f - hot_standby_feedback | off | | f - huge_page_size | 0 | kB | f - huge_pages | try | | f - idle_in_transaction_session_timeout | 0 | ms | f - idle_session_timeout | 0 | ms | f - ignore_checksum_failure | off | | f - ignore_invalid_pages | off | | f - ignore_system_indexes | off | | f - in_hot_standby | off | | f - integer_datetimes | on | | f - jit | off | | f - jit_above_cost | 100000 | | f - jit_debugging_support | off | | f - jit_dump_bitcode | off | | f - jit_expressions | on | | f - jit_inline_above_cost | 500000 | | f - jit_optimize_above_cost | 500000 | | f - jit_profiling_support | off | | f - jit_tuple_deforming | on | | f - join_collapse_limit | 8 | | f - krb_caseins_users | off | | f - lc_collate | C | | f - lc_ctype | C | | f - lc_messages | en_US.utf8 | | f - lc_monetary | en_US.utf-8 | | f - lc_numeric | en_US.utf-8 | | f - lc_time | en_US.utf8 | | f - listen_addresses | * | | f - lo_compat_privileges | off | | f - local_preload_libraries | | | f - lock_timeout | 0 | ms | f - log_autovacuum_min_duration | 600000 | ms | f - log_checkpoints | on | | f - log_connections | on | | f - log_destination | stderr | | f - log_disconnections | on | | f - log_duration | off | | f - log_error_verbosity | default | | f - log_executor_stats | off | | f - log_file_mode | 0600 | | f - log_hostname | off | | f - log_line_prefix | %t-%c- | | f - log_lock_waits | off | | f - log_min_duration_sample | -1 | ms | f - log_min_duration_statement | -1 | ms | f - log_min_error_statement | error | | f - log_min_messages | warning | | f - log_parameter_max_length | -1 | B | f - log_parameter_max_length_on_error | 0 | B | f - log_parser_stats | off | | f - log_planner_stats | off | | f - log_recovery_conflict_waits | off | | f - log_replication_commands | on | | f - log_rotation_age | 60 | min | f - log_rotation_size | 102400 | kB | f - log_startup_progress_interval | 10000 | ms | f - log_statement | none | | f - log_statement_sample_rate | 1 | | f - log_statement_stats | off | | f - log_temp_files | -1 | kB | f - log_timezone | UTC | | f - log_transaction_sample_rate | 0 | | f - log_truncate_on_rotation | off | | f - logging_collector | off | | f - logical_decoding_work_mem | 65536 | kB | f - maintenance_io_concurrency | 10 | | f - maintenance_work_mem | 216064 | kB | f - max_connections | 859 | | f - max_files_per_process | 1000 | | f - max_function_args | 100 | | f - max_identifier_length | 63 | | f - max_index_keys | 32 | | f - max_locks_per_transaction | 64 | | f - max_logical_replication_workers | 4 | | f - max_parallel_maintenance_workers | 64 | | f - max_parallel_workers | 8 | | f - max_parallel_workers_per_gather | 2 | | f - max_pred_locks_per_page | 2 | | f - max_pred_locks_per_relation | -2 | | f - max_pred_locks_per_transaction | 64 | | f - max_prepared_transactions | 0 | | f - max_replication_slots | 10 | | f - max_slot_wal_keep_size | -1 | MB | f - max_stack_depth | 2048 | kB | f - max_standby_archive_delay | 30000 | ms | f - max_standby_streaming_delay | 30000 | ms | f - max_sync_workers_per_subscription | 2 | | f - max_wal_senders | 10 | | f - max_wal_size | 2048 | MB | f - max_worker_processes | 8 | | f - min_dynamic_shared_memory | 0 | MB | f - min_parallel_index_scan_size | 64 | 8kB | f - min_parallel_table_scan_size | 1024 | 8kB | f - min_wal_size | 80 | MB | f - old_snapshot_threshold | -1 | min | f - parallel_leader_participation | on | | f - parallel_setup_cost | 1000 | | f - parallel_tuple_cost | 0.1 | | f - password_encryption | md5 | | f - pg_qs.host_database | azure_sys | | f - pg_qs.index_generation_interval | 15 | | f - pg_qs.interval_length_minutes | 15 | | f - pg_qs.is_enabled_fs | on | | f - pg_qs.max_plan_size | 7500 | | f - pg_qs.max_queries | 500 | | f - pg_qs.max_query_text_length | 6000 | | f - pg_qs.query_capture_mode | none | | f - pg_qs.retention_period_in_days | 7 | | f - pg_qs.store_query_plans | off | | f - pg_qs.track_utility | on | | f - pg_stat_statements.max | 5000 | | f - pg_stat_statements.save | on | | f - pg_stat_statements.track | top | | f - pg_stat_statements.track_planning | off | | f - pg_stat_statements.track_utility | on | | f - pgaadauth.log_min_messages | warning | | f - pgms_stats.is_enabled_fs | on | | f - pgms_wait_sampling.history_period | 100 | | f - pgms_wait_sampling.is_enabled_fs | on | | f - pgms_wait_sampling.query_capture_mode | none | | f - plan_cache_mode | auto | | f - port | 5432 | | f - post_auth_delay | 0 | s | f - pre_auth_delay | 0 | s | f - primary_slot_name | | | f - promote_trigger_file | | | f - quote_all_identifiers | off | | f - random_page_cost | 2 | | f - recovery_end_command | | | f - recovery_init_sync_method | fsync | | f - recovery_min_apply_delay | 0 | ms | f - recovery_prefetch | try | | f - recovery_target | | | f - recovery_target_action | pause | | f - recovery_target_inclusive | on | | f - recovery_target_lsn | | | f - recovery_target_name | | | f - recovery_target_time | | | f - recovery_target_timeline | latest | | f - recovery_target_xid | | | f - recursive_worktable_factor | 10 | | f - restart_after_crash | on | | f - restore_command | | | f - row_security | on | | f - search_path | sokwedb, lookup, upload, "$user" | | f - segment_size | 131072 | 8kB | f - seq_page_cost | 1 | | f - server_encoding | SQL_ASCII | | f - server_version | 15.3 | | f - server_version_num | 150003 | | f - session_replication_role | origin | | f - shared_buffers | 262144 | 8kB | f - shared_memory_size | 2168 | MB | f - shared_memory_size_in_huge_pages | 1084 | | f - shared_memory_type | mmap | | f - ssl | on | | f - ssl_ca_file | /datadrive/certs/ca.pem | | f - ssl_cert_file | /datadrive/certs/cert.pem | | f - ssl_crl_dir | | | f - ssl_crl_file | | | f - ssl_key_file | /datadrive/certs/key.pem | | f - ssl_library | OpenSSL | | f - ssl_passphrase_command_supports_reload | off | | f - ssl_prefer_server_ciphers | on | | f - standard_conforming_strings | on | | f - statement_timeout | 0 | ms | f - stats_fetch_consistency | cache | | f - superuser_reserved_connections | 3 | | f - synchronize_seqscans | on | | f - synchronous_commit | on | | f - synchronous_standby_names | | | f - syslog_facility | local0 | | f - syslog_ident | postgres | | f - syslog_sequence_numbers | on | | f - syslog_split_messages | on | | f - tcp_keepalives_count | 9 | | f - tcp_keepalives_idle | 120 | s | f - tcp_keepalives_interval | 30 | s | f - tcp_user_timeout | 0 | ms | f - temp_buffers | 1024 | 8kB | f - temp_file_limit | -1 | kB | f - temp_tablespaces | | | f - timezone_abbreviations | Default | | f - trace_notify | off | | f - trace_recovery_messages | log | | f - trace_sort | off | | f - track_activities | on | | f - track_activity_query_size | 1024 | B | f - track_commit_timestamp | off | | f - track_counts | on | | f - track_functions | none | | f - track_io_timing | off | | f - track_wal_io_timing | off | | f - transaction_deferrable | off | | f - transaction_isolation | read committed | | f - transaction_read_only | off | | f - transform_null_equals | off | | f - unix_socket_group | | | f - unix_socket_permissions | 0777 | | f - update_process_title | on | | f - vacuum_cost_delay | 0 | ms | f - vacuum_cost_limit | 200 | | f - vacuum_cost_page_dirty | 20 | | f - vacuum_cost_page_hit | 1 | | f - vacuum_cost_page_miss | 2 | | f - vacuum_defer_cleanup_age | 0 | | f - vacuum_failsafe_age | 1600000000 | | f - vacuum_freeze_min_age | 50000000 | | f - vacuum_freeze_table_age | 150000000 | | f - vacuum_multixact_failsafe_age | 1600000000 | | f - vacuum_multixact_freeze_min_age | 5000000 | | f - vacuum_multixact_freeze_table_age | 150000000 | | f - wal_block_size | 8192 | | f - wal_buffers | 2048 | 8kB | f - wal_compression | pglz | | f - wal_consistency_checking | | | f - wal_decode_buffer_size | 524288 | B | f - wal_init_zero | on | | f - wal_keep_size | 400 | MB | f - wal_level | replica | | f - wal_log_hints | off | | f - wal_receiver_create_temp_slot | off | | f - wal_receiver_status_interval | 10 | s | f - wal_receiver_timeout | 60000 | ms | f - wal_recycle | on | | f - wal_retrieve_retry_interval | 5000 | ms | f - wal_segment_size | 16777216 | B | f - wal_sender_timeout | 60000 | ms | f - wal_skip_threshold | 2048 | kB | f - wal_sync_method | fdatasync | | f - wal_writer_delay | 200 | ms | f - wal_writer_flush_after | 128 | 8kB | f - work_mem | 4096 | kB | f - xmlbinary | base64 | | f - xmloption | content | | f - zero_damaged_pages | off | | f + DateStyle | ISO, MDY | | f + IntervalStyle | postgres | | f + TimeZone | UCT | | f + allow_in_place_tablespaces | off | | f + allow_system_table_mods | off | | f + application_name | psql | | f + archive_cleanup_command | | | f + archive_command | BlobLogUpload.sh %f %p | | f + archive_library | | | f + archive_mode | always | | f + archive_timeout | 300 | s | f + array_nulls | on | | f + authentication_timeout | 30 | s | f + autovacuum | on | | f + autovacuum_analyze_scale_factor | 0.1 | | f + autovacuum_analyze_threshold | 50 | | f + autovacuum_freeze_max_age | 200000000 | | f + autovacuum_max_workers | 3 | | f + autovacuum_multixact_freeze_max_age | 400000000 | | f + autovacuum_naptime | 60 | s | f + autovacuum_vacuum_cost_delay | 2 | ms | f + autovacuum_vacuum_cost_limit | -1 | | f + autovacuum_vacuum_insert_scale_factor | 0.2 | | f + autovacuum_vacuum_insert_threshold | 1000 | | f + autovacuum_vacuum_scale_factor | 0.2 | | f + autovacuum_vacuum_threshold | 50 | | f + autovacuum_work_mem | -1 | kB | f + azure.accepted_password_auth_method | md5 | | f + azure.allowed_error_codes | | | f + azure.crash_active_hotstandby_on_conflict_parameter | on | | f + azure.custom_path | /datadrive/pg/data | | f + azure.customer_resource_group | DBResources | | f + azure.customer_subscription_id | 94cd8cb7-d645-497b-b140-b281f40a5c96 | | f + azure.enable_is_db_alive | on | | f + azure.enable_temp_tablespaces_on_local_ssd | on | | f + azure.enable_threat_protection | off | | f + azure.enforce_ha_quorom | off | | f + azure.extensions | | | f + azure.single_to_flex_migration | off | | f + azure.threat_protection_app_type_name | PostgreSQL.Flexible | | f + azure.waittime_is_db_alive | 10000 | | f + backend_flush_after | 256 | 8kB | f + backslash_quote | safe_encoding | | f + backtrace_functions | | | f + bgwriter_delay | 20 | ms | f + bgwriter_flush_after | 64 | 8kB | f + bgwriter_lru_maxpages | 100 | | f + bgwriter_lru_multiplier | 2 | | f + block_size | 8192 | | f + bonjour | off | | f + bonjour_name | | | f + bytea_output | hex | | f + check_function_bodies | on | | f + checkpoint_completion_target | 0.9 | | f + checkpoint_flush_after | 32 | 8kB | f + checkpoint_timeout | 600 | s | f + checkpoint_warning | 30 | s | f + client_connection_check_interval | 0 | ms | f + client_encoding | UTF8 | | f + client_min_messages | notice | | f + cluster_name | | | f + commit_delay | 0 | | f + commit_siblings | 5 | | f + compute_query_id | auto | | f + config_file | /datadrive/pg/data/postgresql.conf | | f + constraint_exclusion | partition | | f + cpu_index_tuple_cost | 0.005 | | f + cpu_operator_cost | 0.0025 | | f + cpu_tuple_cost | 0.01 | | f + cron.database_name | postgres | | f + cron.enable_superuser_jobs | off | | f + cron.host | /tmp | | f + cron.log_min_messages | warning | | f + cron.log_run | on | | f + cron.log_statement | on | | f + cron.max_running_jobs | 32 | | f + cron.use_background_workers | off | | f + cursor_tuple_fraction | 0.1 | | f + data_checksums | on | | f + data_directory | /datadrive/pg/data | | f + data_directory_mode | 0700 | | f + data_sync_retry | off | | f + db_user_namespace | off | | f + deadlock_timeout | 1000 | ms | f + debug_assertions | off | | f + debug_discard_caches | 0 | | f + debug_pretty_print | on | | f + debug_print_parse | off | | f + debug_print_plan | off | | f + debug_print_rewritten | off | | f + default_statistics_target | 100 | | f + default_table_access_method | heap | | f + default_tablespace | | | f + default_text_search_config | pg_catalog.english | | f + default_toast_compression | pglz | | f + default_transaction_deferrable | off | | f + default_transaction_isolation | serializable | | f + default_transaction_read_only | off | | f + dynamic_library_path | $libdir | | f + dynamic_shared_memory_type | posix | | f + effective_cache_size | 786432 | 8kB | f + effective_io_concurrency | 1 | | f + enable_async_append | on | | f + enable_bitmapscan | on | | f + enable_gathermerge | on | | f + enable_hashagg | on | | f + enable_hashjoin | on | | f + enable_incremental_sort | on | | f + enable_indexonlyscan | on | | f + enable_indexscan | on | | f + enable_material | on | | f + enable_memoize | on | | f + enable_mergejoin | on | | f + enable_nestloop | on | | f + enable_parallel_append | on | | f + enable_parallel_hash | on | | f + enable_partition_pruning | on | | f + enable_partitionwise_aggregate | off | | f + enable_partitionwise_join | off | | f + enable_seqscan | on | | f + enable_sort | on | | f + enable_tidscan | on | | f + escape_string_warning | on | | f + event_source | PostgreSQL | | f + exit_on_error | off | | f + external_pid_file | | | f + extra_float_digits | 1 | | f + force_parallel_mode | off | | f + from_collapse_limit | 8 | | f + fsync | on | | f + full_page_writes | on | | f + geqo | on | | f + geqo_effort | 5 | | f + geqo_generations | 0 | | f + geqo_pool_size | 0 | | f + geqo_seed | 0 | | f + geqo_selection_bias | 2 | | f + geqo_threshold | 12 | | f + gin_fuzzy_search_limit | 0 | | f + gin_pending_list_limit | 4096 | kB | f + hash_mem_multiplier | 2 | | f + hba_file | /datadrive/pg/data/pg_hba.conf | | f + hot_standby | on | | f + hot_standby_feedback | off | | f + huge_page_size | 0 | kB | f + huge_pages | try | | f + ident_file | /datadrive/pg/data/pg_ident.conf | | f + idle_in_transaction_session_timeout | 0 | ms | f + idle_session_timeout | 0 | ms | f + ignore_checksum_failure | off | | f + ignore_invalid_pages | off | | f + ignore_system_indexes | off | | f + in_hot_standby | off | | f + integer_datetimes | on | | f + jit | off | | f + jit_above_cost | 100000 | | f + jit_debugging_support | off | | f + jit_dump_bitcode | off | | f + jit_expressions | on | | f + jit_inline_above_cost | 500000 | | f + jit_optimize_above_cost | 500000 | | f + jit_profiling_support | off | | f + jit_provider | llvmjit | | f + jit_tuple_deforming | on | | f + join_collapse_limit | 8 | | f + krb_caseins_users | off | | f + krb_server_keyfile | | | f + lc_collate | C | | f + lc_ctype | C | | f + lc_messages | en_US.utf8 | | f + lc_monetary | en_US.utf-8 | | f + lc_numeric | en_US.utf-8 | | f + lc_time | en_US.utf8 | | f + listen_addresses | * | | f + lo_compat_privileges | off | | f + local_preload_libraries | | | f + lock_timeout | 0 | ms | f + log_autovacuum_min_duration | 600000 | ms | f + log_checkpoints | on | | f + log_connections | on | | f + log_destination | stderr | | f + log_directory | log | | f + log_disconnections | on | | f + log_duration | off | | f + log_error_verbosity | default | | f + log_executor_stats | off | | f + log_file_mode | 0600 | | f + log_filename | postgresql-%Y-%m-%d_%H%M%S.log | | f + log_hostname | off | | f + log_line_prefix | %t-%c- | | f + log_lock_waits | off | | f + log_min_duration_sample | -1 | ms | f + log_min_duration_statement | -1 | ms | f + log_min_error_statement | error | | f + log_min_messages | warning | | f + log_parameter_max_length | -1 | B | f + log_parameter_max_length_on_error | 0 | B | f + log_parser_stats | off | | f + log_planner_stats | off | | f + log_recovery_conflict_waits | off | | f + log_replication_commands | on | | f + log_rotation_age | 60 | min | f + log_rotation_size | 102400 | kB | f + log_startup_progress_interval | 10000 | ms | f + log_statement | none | | f + log_statement_sample_rate | 1 | | f + log_statement_stats | off | | f + log_temp_files | -1 | kB | f + log_timezone | UTC | | f + log_transaction_sample_rate | 0 | | f + log_truncate_on_rotation | off | | f + logging_collector | off | | f + logical_decoding_work_mem | 65536 | kB | f + maintenance_io_concurrency | 10 | | f + maintenance_work_mem | 216064 | kB | f + max_connections | 859 | | f + max_files_per_process | 1000 | | f + max_function_args | 100 | | f + max_identifier_length | 63 | | f + max_index_keys | 32 | | f + max_locks_per_transaction | 64 | | f + max_logical_replication_workers | 4 | | f + max_parallel_maintenance_workers | 64 | | f + max_parallel_workers | 8 | | f + max_parallel_workers_per_gather | 2 | | f + max_pred_locks_per_page | 2 | | f + max_pred_locks_per_relation | -2 | | f + max_pred_locks_per_transaction | 64 | | f + max_prepared_transactions | 0 | | f + max_replication_slots | 10 | | f + max_slot_wal_keep_size | -1 | MB | f + max_stack_depth | 2048 | kB | f + max_standby_archive_delay | 30000 | ms | f + max_standby_streaming_delay | 30000 | ms | f + max_sync_workers_per_subscription | 2 | | f + max_wal_senders | 10 | | f + max_wal_size | 2048 | MB | f + max_worker_processes | 8 | | f + min_dynamic_shared_memory | 0 | MB | f + min_parallel_index_scan_size | 64 | 8kB | f + min_parallel_table_scan_size | 1024 | 8kB | f + min_wal_size | 80 | MB | f + old_snapshot_threshold | -1 | min | f + parallel_leader_participation | on | | f + parallel_setup_cost | 1000 | | f + parallel_tuple_cost | 0.1 | | f + password_encryption | md5 | | f + pg_qs.host_database | azure_sys | | f + pg_qs.index_generation_interval | 15 | | f + pg_qs.interval_length_minutes | 15 | | f + pg_qs.is_enabled_fs | on | | f + pg_qs.max_plan_size | 7500 | | f + pg_qs.max_queries | 500 | | f + pg_qs.max_query_text_length | 6000 | | f + pg_qs.query_capture_mode | none | | f + pg_qs.retention_period_in_days | 7 | | f + pg_qs.store_query_plans | off | | f + pg_qs.track_utility | on | | f + pg_stat_statements.max | 5000 | | f + pg_stat_statements.save | on | | f + pg_stat_statements.track | top | | f + pg_stat_statements.track_planning | off | | f + pg_stat_statements.track_utility | on | | f + pgaadauth.aad_auth_connection_healthcheck_client_id | | | f + pgaadauth.aad_auth_connection_healthcheck_database_name | azure_maintenance | | f + pgaadauth.aad_auth_connection_healthcheck_role_name | aad_auth_connection_health_check | | f + pgaadauth.audience | | | f + pgaadauth.authentication_endpoint | | | f + pgaadauth.federation_metadata_endpoint | | | f + pgaadauth.graph_access_token | **** | | f + pgaadauth.graph_access_token_expires_on | | | f + pgaadauth.graph_api_endpoint | | | f + pgaadauth.issuer_prefix | | | f + pgaadauth.log_min_messages | warning | | f + pgaadauth.min_fetch_signature_sec | 1800 | | f + pgaadauth.password_auth_enabled | on | | f + pgaadauth.sid_cache_retain_sec | 60 | | f + pgaadauth.tenant_id | | | f + pgaadauth.validation_mode | default | | f + pgms_stats.is_enabled_fs | on | | f + pgms_wait_sampling.history_period | 100 | | f + pgms_wait_sampling.is_enabled_fs | on | | f + pgms_wait_sampling.query_capture_mode | none | | f + plan_cache_mode | auto | | f + port | 5432 | | f + post_auth_delay | 0 | s | f + pre_auth_delay | 0 | s | f + primary_conninfo | | | f + primary_slot_name | | | f + promote_trigger_file | | | f + quote_all_identifiers | off | | f + random_page_cost | 2 | | f + recovery_end_command | | | f + recovery_init_sync_method | fsync | | f + recovery_min_apply_delay | 0 | ms | f + recovery_prefetch | try | | f + recovery_target | | | f + recovery_target_action | pause | | f + recovery_target_inclusive | on | | f + recovery_target_lsn | | | f + recovery_target_name | | | f + recovery_target_time | | | f + recovery_target_timeline | latest | | f + recovery_target_xid | | | f + recursive_worktable_factor | 10 | | f + restart_after_crash | on | | f + restore_command | | | f + row_security | on | | f + search_path | sokwedb, lookup, upload, "$user" | | f + segment_size | 131072 | 8kB | f + seq_page_cost | 1 | | f + server_encoding | SQL_ASCII | | f + server_version | 15.3 | | f + server_version_num | 150003 | | f + session_preload_libraries | | | f + session_replication_role | origin | | f + shared_buffers | 262144 | 8kB | f + shared_memory_size | 2168 | MB | f + shared_memory_size_in_huge_pages | 1084 | | f + shared_memory_type | mmap | | f + shared_preload_libraries | azure,pg_cron,pg_qs,pg_stat_statements,pgaadauth,pgms_stats,pgms_wait_sampling | | f + ssl | on | | f + ssl_ca_file | /datadrive/certs/ca.pem | | f + ssl_cert_file | /datadrive/certs/cert.pem | | f + ssl_ciphers | ECDHE-ECDSA-AES256-GCM-SHA384:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-CHACHA20-POLY1305:ECDHE-RSA-CHACHA20-POLY1305:ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES128-GCM-SHA256 | | f + ssl_crl_dir | | | f + ssl_crl_file | | | f + ssl_dh_params_file | | | f + ssl_ecdh_curve | prime256v1 | | f + ssl_key_file | /datadrive/certs/key.pem | | f + ssl_library | OpenSSL | | f + ssl_max_protocol_version | | | f + ssl_min_protocol_version | TLSv1.2 | | f + ssl_passphrase_command | | | f + ssl_passphrase_command_supports_reload | off | | f + ssl_prefer_server_ciphers | on | | f + standard_conforming_strings | on | | f + statement_timeout | 0 | ms | f + stats_fetch_consistency | cache | | f + superuser_reserved_connections | 3 | | f + synchronize_seqscans | on | | f + synchronous_commit | on | | f + synchronous_standby_names | | | f + syslog_facility | local0 | | f + syslog_ident | postgres | | f + syslog_sequence_numbers | on | | f + syslog_split_messages | on | | f + tcp_keepalives_count | 9 | | f + tcp_keepalives_idle | 120 | s | f + tcp_keepalives_interval | 30 | s | f + tcp_user_timeout | 0 | ms | f + temp_buffers | 1024 | 8kB | f + temp_file_limit | -1 | kB | f + temp_tablespaces | | | f + timezone_abbreviations | Default | | f + trace_notify | off | | f + trace_recovery_messages | log | | f + trace_sort | off | | f + track_activities | on | | f + track_activity_query_size | 1024 | B | f + track_commit_timestamp | off | | f + track_counts | on | | f + track_functions | none | | f + track_io_timing | off | | f + track_wal_io_timing | off | | f + transaction_deferrable | off | | f + transaction_isolation | serializable | | f + transaction_read_only | off | | f + transform_null_equals | off | | f + unix_socket_directories | /tmp | | f + unix_socket_group | | | f + unix_socket_permissions | 0777 | | f + update_process_title | on | | f + vacuum_cost_delay | 0 | ms | f + vacuum_cost_limit | 200 | | f + vacuum_cost_page_dirty | 20 | | f + vacuum_cost_page_hit | 1 | | f + vacuum_cost_page_miss | 2 | | f + vacuum_defer_cleanup_age | 0 | | f + vacuum_failsafe_age | 1600000000 | | f + vacuum_freeze_min_age | 50000000 | | f + vacuum_freeze_table_age | 150000000 | | f + vacuum_multixact_failsafe_age | 1600000000 | | f + vacuum_multixact_freeze_min_age | 5000000 | | f + vacuum_multixact_freeze_table_age | 150000000 | | f + wal_block_size | 8192 | | f + wal_buffers | 2048 | 8kB | f + wal_compression | pglz | | f + wal_consistency_checking | | | f + wal_decode_buffer_size | 524288 | B | f + wal_init_zero | on | | f + wal_keep_size | 400 | MB | f + wal_level | replica | | f + wal_log_hints | off | | f + wal_receiver_create_temp_slot | off | | f + wal_receiver_status_interval | 10 | s | f + wal_receiver_timeout | 60000 | ms | f + wal_recycle | on | | f + wal_retrieve_retry_interval | 5000 | ms | f + wal_segment_size | 16777216 | B | f + wal_sender_timeout | 60000 | ms | f + wal_skip_threshold | 2048 | kB | f + wal_sync_method | fdatasync | | f + wal_writer_delay | 200 | ms | f + wal_writer_flush_after | 128 | 8kB | f + work_mem | 4096 | kB | f + xmlbinary | base64 | | f + xmloption | content | | f + zero_damaged_pages | off | | f -- 2.34.1