# PostgreSQL 13 → 14 GUC 差异

> PG13 与 PG14 之间新增、boot 默认值变化和移除的核心配置参数。
---

> [!NOTE]
> **Fact。** 实测在档数从 332 变为 348；新增 18、boot 默认值变化 5、移除 2。

## 新增参数 {#added}

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

## Boot 默认值变化 {#default-changes}

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

## 移除参数 {#removed}

| 参数 | 最后类型 | Context | 最后 Boot 默认值 | 分类 |
| --- | --- | --- | --- | --- |
| [`operator_precedence_warning`](/zh/parameters/operator-precedence-warning/) | `bool` | `user` | `off` | Version and Platform Compatibility / Previous PostgreSQL Versions |
| [`vacuum_cleanup_index_scale_factor`](/zh/parameters/vacuum-cleanup-index-scale-factor/) | `real` | `user` | `0.1` | Client Connection Defaults / Statement Behavior |
{.full-width}

## 计算方法 {#method}

三张清单直接比较固定环境中的 PG13 与 PG14 `pg_settings` 快照。默认值变化使用 `boot_val` 与 `unit` 的组合；`setting` 不参与判定，以免把 `initdb` 生成值误当作编译时默认值。

- [机器可读差异数据](/data/diffs.json)
- [完整 GUC JSONL](/data/guc.jsonl)