# PostgreSQL 10 → 11 GUC 差异

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

> [!NOTE]
> **Fact。** 实测在档数从 272 变为 292；新增 21、boot 默认值变化 4、移除 1。

## 新增参数 {#added}

| 参数 | 类型 | Context | Boot 默认值 | 分类 |
| --- | --- | --- | --- | --- |
| [`data_directory_mode`](/zh/parameters/data-directory-mode/) | `integer` | `internal` | `448` | Preset Options |
| [`enable_parallel_append`](/zh/parameters/enable-parallel-append/) | `bool` | `user` | `on` | Query Tuning / Planner Method Configuration |
| [`enable_parallel_hash`](/zh/parameters/enable-parallel-hash/) | `bool` | `user` | `on` | Query Tuning / Planner Method Configuration |
| [`enable_partition_pruning`](/zh/parameters/enable-partition-pruning/) | `bool` | `user` | `on` | Query Tuning / Planner Method Configuration |
| [`enable_partitionwise_aggregate`](/zh/parameters/enable-partitionwise-aggregate/) | `bool` | `user` | `off` | Query Tuning / Planner Method Configuration |
| [`enable_partitionwise_join`](/zh/parameters/enable-partitionwise-join/) | `bool` | `user` | `off` | Query Tuning / Planner Method Configuration |
| [`jit`](/zh/parameters/jit/) | `bool` | `user` | `off` | Query Tuning / Other Planner Options |
| [`jit_above_cost`](/zh/parameters/jit-above-cost/) | `real` | `user` | `100000` | Query Tuning / Planner Cost Constants |
| [`jit_debugging_support`](/zh/parameters/jit-debugging-support/) | `bool` | `superuser-backend` | `off` | Developer Options |
| [`jit_dump_bitcode`](/zh/parameters/jit-dump-bitcode/) | `bool` | `superuser` | `off` | Developer Options |
| [`jit_expressions`](/zh/parameters/jit-expressions/) | `bool` | `user` | `on` | Developer Options |
| [`jit_inline_above_cost`](/zh/parameters/jit-inline-above-cost/) | `real` | `user` | `500000` | Query Tuning / Planner Cost Constants |
| [`jit_optimize_above_cost`](/zh/parameters/jit-optimize-above-cost/) | `real` | `user` | `500000` | Query Tuning / Planner Cost Constants |
| [`jit_profiling_support`](/zh/parameters/jit-profiling-support/) | `bool` | `superuser-backend` | `off` | Developer Options |
| [`jit_provider`](/zh/parameters/jit-provider/) | `string` | `postmaster` | `llvmjit` | Client Connection Defaults / Shared Library Preloading |
| [`jit_tuple_deforming`](/zh/parameters/jit-tuple-deforming/) | `bool` | `user` | `on` | Developer Options |
| [`max_parallel_maintenance_workers`](/zh/parameters/max-parallel-maintenance-workers/) | `integer` | `user` | `2` | Resource Usage / Asynchronous Behavior |
| [`parallel_leader_participation`](/zh/parameters/parallel-leader-participation/) | `bool` | `user` | `on` | Resource Usage / Asynchronous Behavior |
| [`ssl_passphrase_command`](/zh/parameters/ssl-passphrase-command/) | `string` | `sighup` | `""` (empty string) | Connections and Authentication / SSL |
| [`ssl_passphrase_command_supports_reload`](/zh/parameters/ssl-passphrase-command-supports-reload/) | `bool` | `sighup` | `off` | Connections and Authentication / SSL |
| [`vacuum_cleanup_index_scale_factor`](/zh/parameters/vacuum-cleanup-index-scale-factor/) | `real` | `user` | `0.1` | Client Connection Defaults / Statement Behavior |
{.full-width}

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

| 参数 | PG10 | PG11 | 分类 |
| --- | --- | --- | --- |
| [`server_version`](/zh/parameters/server-version/) | `10.23 (Debian 10.23-1.pgdg110+1)` | `11.22 (Debian 11.22-1.pgdg120+1)` | Preset Options |
| [`server_version_num`](/zh/parameters/server-version-num/) | `100023` | `110022` | Preset Options |
| [`track_activity_query_size`](/zh/parameters/track-activity-query-size/) | `1024` | `1024 B` (1 KiB) | Resource Usage / Memory |
| [`wal_segment_size`](/zh/parameters/wal-segment-size/) | `2048 8kB` (16 MiB (2048 × 8kB)) | `16777216 B` (16 MiB) | Preset Options |
{.full-width}

## 移除参数 {#removed}

| 参数 | 最后类型 | Context | 最后 Boot 默认值 | 分类 |
| --- | --- | --- | --- | --- |
| [`replacement_sort_tuples`](/zh/parameters/replacement-sort-tuples/) | `integer` | `user` | `150000` | Resource Usage / Memory |
{.full-width}

## 计算方法 {#method}

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

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