Parameters
This section contains all 447 core GUCs in the measured PostgreSQL 9.0–19 Beta 3 union: 419 remain in 19 Beta 3, 28 were removed during the interval, and 240 first appear after 9.0. Every dossier includes identity, lifecycle, default history, mechanism, tuning advice, Pigsty values, pitfalls, related entries, and sources.
Categories
| Category | Parameters |
|---|---|
| Client Connection Defaults | 47 |
| Connections and Authentication | 45 |
| Customized Options | 1 |
| Developer Options | 27 |
| Error Handling | 4 |
| File Locations | 7 |
| Lock Management | 5 |
| Preset Options | 24 |
| Query Tuning | 55 |
| Replication | 33 |
| Reporting and Logging | 47 |
| Resource Usage | 51 |
| Statistics | 14 |
| Vacuuming | 34 |
| Version and Platform Compatibility | 12 |
| Write-Ahead Log | 41 |
Boot defaults that changed
These parameters changed boot_val or unit during PostgreSQL 9.0–19 Beta 3:
TimeZone · autovacuum_vacuum_cost_delay · checkpoint_completion_target · default_toast_compression · effective_cache_size · effective_io_concurrency · extra_float_digits · hash_mem_multiplier · hot_standby · jit · krb_server_keyfile · log_autovacuum_min_duration · log_checkpoints · log_connections · log_directory · log_line_prefix · log_lock_waits · log_timezone · maintenance_io_concurrency · maintenance_work_mem · max_locks_per_transaction · max_parallel_workers_per_gather · max_replication_slots · max_wal_senders · max_wal_size · min_wal_size · password_encryption · search_path · server_version · server_version_num · shared_buffers · ssl_ciphers · ssl_min_protocol_version · standard_conforming_strings · timezone_abbreviations · track_activity_query_size · transaction_isolation · vacuum_buffer_usage_limit · vacuum_cost_page_miss · wal_buffers · wal_level · wal_segment_size · wal_sender_delay · work_mem
Removed parameters
These parameters left pg_settings before PostgreSQL 19 Beta 3 and retain historical dossiers:
checkpoint_segments · custom_variable_classes · db_user_namespace · default_with_oids · escape_string_warning · extension_destdir · force_parallel_mode · io_workers · krb_srvname · lc_collate · lc_ctype · min_parallel_relation_size · old_snapshot_threshold · operator_precedence_warning · promote_trigger_file · replacement_sort_tuples · replication_timeout · silent_mode · sql_inheritance · ssl_ecdh_curve · ssl_renegotiation_limit · stats_temp_directory · trace_recovery_messages · unix_socket_directory · vacuum_cleanup_index_scale_factor · vacuum_defer_cleanup_age · wal_keep_segments · wal_sender_delay
Client Connection Defaults
Complete dossiers for 47 core PostgreSQL settings in Client Connection Defaults.
Connections and Authentication
Complete dossiers for 45 core PostgreSQL settings in Connections and Authentication.
Customized Options
Complete dossiers for 1 core PostgreSQL settings in Customized Options.
Developer Options
Complete dossiers for 27 core PostgreSQL settings in Developer Options.
Error Handling
Complete dossiers for 4 core PostgreSQL settings in Error Handling.
File Locations
Complete dossiers for 7 core PostgreSQL settings in File Locations.
Lock Management
Complete dossiers for 5 core PostgreSQL settings in Lock Management.
Preset Options
Complete dossiers for 24 core PostgreSQL settings in Preset Options.
Query Tuning
Complete dossiers for 55 core PostgreSQL settings in Query Tuning.
Replication
Complete dossiers for 33 core PostgreSQL settings in Replication.
Reporting and Logging
Complete dossiers for 47 core PostgreSQL settings in Reporting and Logging.
Resource Usage
Complete dossiers for 51 core PostgreSQL settings in Resource Usage.
Statistics
Complete dossiers for 14 core PostgreSQL settings in Statistics.
Vacuuming
Complete dossiers for 34 core PostgreSQL settings in Vacuuming.
Version and Platform Compatibility
Complete dossiers for 12 core PostgreSQL settings in Version and Platform Compatibility.
Write-Ahead Log
Complete dossiers for 41 core PostgreSQL settings in Write-Ahead Log.