# PostgreSQL 13 → 14 GUC diff

> Core configuration parameters added, removed, or changed in boot default between PostgreSQL 13 and 14.
---

> [!NOTE]
> **Fact.** The measured inventory changes from 332 to 348 settings: 18 added, 5 boot-default changes, and 2 removed.

## Added parameters {#added}

| Parameter | Type | Context | Boot default | Category |
| --- | --- | --- | --- | --- |
| [`client_connection_check_interval`](/parameters/client-connection-check-interval/) | `integer` | `user` | `0 ms` | Connections and Authentication / Connection Settings |
| [`compute_query_id`](/parameters/compute-query-id/) | `enum` | `superuser` | `auto` | Statistics / Monitoring |
| [`debug_discard_caches`](/parameters/debug-discard-caches/) | `integer` | `superuser` | `0` | Developer Options |
| [`default_toast_compression`](/parameters/default-toast-compression/) | `enum` | `user` | `pglz` | Client Connection Defaults / Statement Behavior |
| [`enable_async_append`](/parameters/enable-async-append/) | `bool` | `user` | `on` | Query Tuning / Planner Method Configuration |
| [`enable_memoize`](/parameters/enable-memoize/) | `bool` | `user` | `on` | Query Tuning / Planner Method Configuration |
| [`huge_page_size`](/parameters/huge-page-size/) | `integer` | `postmaster` | `0 kB` (0 B) | Resource Usage / Memory |
| [`idle_session_timeout`](/parameters/idle-session-timeout/) | `integer` | `user` | `0 ms` | Client Connection Defaults / Statement Behavior |
| [`in_hot_standby`](/parameters/in-hot-standby/) | `bool` | `internal` | `off` | Preset Options |
| [`log_recovery_conflict_waits`](/parameters/log-recovery-conflict-waits/) | `bool` | `sighup` | `off` | Reporting and Logging / What to Log |
| [`min_dynamic_shared_memory`](/parameters/min-dynamic-shared-memory/) | `integer` | `postmaster` | `0 MB` (0 B) | Resource Usage / Memory |
| [`output_plugin_libraries`](/parameters/output-plugin-libraries/) | `string` | `superuser` | `pgoutput, test_decoding` | Replication / Sending Servers |
| [`recovery_init_sync_method`](/parameters/recovery-init-sync-method/) | `enum` | `sighup` | `fsync` | Error Handling |
| [`remove_temp_files_after_crash`](/parameters/remove-temp-files-after-crash/) | `bool` | `sighup` | `on` | Developer Options |
| [`ssl_crl_dir`](/parameters/ssl-crl-dir/) | `string` | `sighup` | `""` (empty string) | Connections and Authentication / SSL |
| [`track_wal_io_timing`](/parameters/track-wal-io-timing/) | `bool` | `superuser` | `off` | Statistics / Query and Index Statistics Collector |
| [`vacuum_failsafe_age`](/parameters/vacuum-failsafe-age/) | `integer` | `user` | `1600000000` | Client Connection Defaults / Statement Behavior |
| [`vacuum_multixact_failsafe_age`](/parameters/vacuum-multixact-failsafe-age/) | `integer` | `user` | `1600000000` | Client Connection Defaults / Statement Behavior |
{.full-width}

## Boot-default changes {#default-changes}

| Parameter | PG13 | PG14 | Category |
| --- | --- | --- | --- |
| [`checkpoint_completion_target`](/parameters/checkpoint-completion-target/) | `0.5` | `0.9` | Write-Ahead Log / Checkpoints |
| [`password_encryption`](/parameters/password-encryption/) | `md5` | `scram-sha-256` | Connections and Authentication / Authentication |
| [`server_version`](/parameters/server-version/) | `13.23 (Debian 13.23-1.pgdg13+1)` | `14.24 (Debian 14.24-1.pgdg13+2)` | Preset Options |
| [`server_version_num`](/parameters/server-version-num/) | `130023` | `140024` | Preset Options |
| [`vacuum_cost_page_miss`](/parameters/vacuum-cost-page-miss/) | `10` | `2` | Resource Usage / Cost-Based Vacuum Delay |
{.full-width}

## Removed parameters {#removed}

| Parameter | Last type | Context | Last boot default | Category |
| --- | --- | --- | --- | --- |
| [`operator_precedence_warning`](/parameters/operator-precedence-warning/) | `bool` | `user` | `off` | Version and Platform Compatibility / Previous PostgreSQL Versions |
| [`vacuum_cleanup_index_scale_factor`](/parameters/vacuum-cleanup-index-scale-factor/) | `real` | `user` | `0.1` | Client Connection Defaults / Statement Behavior |
{.full-width}

## Method {#method}

The three lists compare the pinned PG13 and PG14 `pg_settings` snapshots directly. A default change is a change in the `boot_val` plus `unit` pair; `setting` is excluded so an `initdb`-generated value is not mistaken for the compiled boot default.

- [Machine-readable diff data](/data/diffs.json)
- [Complete GUC JSONL](/data/guc.jsonl)