# PostgreSQL 18 → 19 Beta 3 GUC 差异

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

> [!NOTE]
> **Fact。** 实测在档数从 399 变为 419；新增 22、boot 默认值变化 6、移除 2。

## 新增参数 {#added}

| 参数 | 类型 | Context | Boot 默认值 | 分类 |
| --- | --- | --- | --- | --- |
| [`autovacuum_analyze_score_weight`](/zh/parameters/autovacuum-analyze-score-weight/) | `real` | `sighup` | `1` | Vacuuming / Automatic Vacuuming |
| [`autovacuum_freeze_score_weight`](/zh/parameters/autovacuum-freeze-score-weight/) | `real` | `sighup` | `1` | Vacuuming / Automatic Vacuuming |
| [`autovacuum_max_parallel_workers`](/zh/parameters/autovacuum-max-parallel-workers/) | `integer` | `sighup` | `0` | Vacuuming / Automatic Vacuuming |
| [`autovacuum_multixact_freeze_score_weight`](/zh/parameters/autovacuum-multixact-freeze-score-weight/) | `real` | `sighup` | `1` | Vacuuming / Automatic Vacuuming |
| [`autovacuum_vacuum_insert_score_weight`](/zh/parameters/autovacuum-vacuum-insert-score-weight/) | `real` | `sighup` | `1` | Vacuuming / Automatic Vacuuming |
| [`autovacuum_vacuum_score_weight`](/zh/parameters/autovacuum-vacuum-score-weight/) | `real` | `sighup` | `1` | Vacuuming / Automatic Vacuuming |
| [`debug_exec_backend`](/zh/parameters/debug-exec-backend/) | `bool` | `internal` | `off` | Preset Options |
| [`debug_print_raw_parse`](/zh/parameters/debug-print-raw-parse/) | `bool` | `user` | `off` | Reporting and Logging / What to Log |
| [`effective_wal_level`](/zh/parameters/effective-wal-level/) | `enum` | `internal` | `replica` | Preset Options |
| [`enable_eager_aggregate`](/zh/parameters/enable-eager-aggregate/) | `bool` | `user` | `on` | Query Tuning / Planner Method Configuration |
| [`hosts_file`](/zh/parameters/hosts-file/) | `string` | `postmaster` | — (not set) | File Locations |
| [`io_max_workers`](/zh/parameters/io-max-workers/) | `integer` | `sighup` | `8` | Resource Usage / I/O |
| [`io_min_workers`](/zh/parameters/io-min-workers/) | `integer` | `sighup` | `2` | Resource Usage / I/O |
| [`io_worker_idle_timeout`](/zh/parameters/io-worker-idle-timeout/) | `integer` | `sighup` | `60000 ms` (1 min) | Resource Usage / I/O |
| [`io_worker_launch_interval`](/zh/parameters/io-worker-launch-interval/) | `integer` | `sighup` | `100 ms` | Resource Usage / I/O |
| [`log_autoanalyze_min_duration`](/zh/parameters/log-autoanalyze-min-duration/) | `integer` | `sighup` | `600000 ms` (10 min) | Reporting and Logging / What to Log |
| [`max_repack_replication_slots`](/zh/parameters/max-repack-replication-slots/) | `integer` | `postmaster` | `5` | Replication / Sending Servers |
| [`min_eager_agg_group_size`](/zh/parameters/min-eager-agg-group-size/) | `real` | `user` | `8` | Query Tuning / Planner Cost Constants |
| [`password_expiration_warning_threshold`](/zh/parameters/password-expiration-warning-threshold/) | `integer` | `sighup` | `604800 s` (7 d) | Connections and Authentication / Authentication |
| [`ssl_sni`](/zh/parameters/ssl-sni/) | `bool` | `sighup` | `off` | Connections and Authentication / SSL |
| [`timing_clock_source`](/zh/parameters/timing-clock-source/) | `enum` | `superuser` | `auto` | Resource Usage / Time |
| [`wal_sender_shutdown_timeout`](/zh/parameters/wal-sender-shutdown-timeout/) | `integer` | `user` | `-1 ms` | Replication / Sending Servers |
{.full-width}

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

| 参数 | PG18 | PG19 Beta 3 | 分类 |
| --- | --- | --- | --- |
| [`default_toast_compression`](/zh/parameters/default-toast-compression/) | `pglz` | `lz4` | Client Connection Defaults / Statement Behavior |
| [`jit`](/zh/parameters/jit/) | `on` | `off` | Query Tuning / Other Planner Options |
| [`log_lock_waits`](/zh/parameters/log-lock-waits/) | `off` | `on` | Reporting and Logging / What to Log |
| [`max_locks_per_transaction`](/zh/parameters/max-locks-per-transaction/) | `64` | `128` | Lock Management |
| [`server_version`](/zh/parameters/server-version/) | `18.6 (Debian 18.6-1.pgdg13+2)` | `19beta3 (Debian 19~beta3-1.pgdg13+1)` | Preset Options |
| [`server_version_num`](/zh/parameters/server-version-num/) | `180006` | `190000` | Preset Options |
{.full-width}

## 移除参数 {#removed}

| 参数 | 最后类型 | Context | 最后 Boot 默认值 | 分类 |
| --- | --- | --- | --- | --- |
| [`escape_string_warning`](/zh/parameters/escape-string-warning/) | `bool` | `user` | `on` | Version and Platform Compatibility / Previous PostgreSQL Versions |
| [`io_workers`](/zh/parameters/io-workers/) | `integer` | `sighup` | `3` | Resource Usage / I/O |
{.full-width}

## 计算方法 {#method}

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

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