Planner statistics preserved on major version upgrade
Recorded source states and original language descriptions. Missing version evidence stays unknown.
The source snapshot records transitions for PostgreSQL 8.1–18. The historical matrix records independent cells for 7.4–18. Neither records support for PostgreSQL 19 or 20; newer versions remain unknown. These source claims are distinct from runtime measurements.
Upgrade
Description
PostgreSQL now keeps planner statistics through a major version upgrade, which helps an upgraded cluster reach expected performance more quickly after the upgrade. See the statistics section in pg_upgrade for more information.
Selected version: PostgreSQL 18
Yes
Compare versions
Original documentation links
Complete source facts and provenance
yaml · center · 1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd
{
"Key": "planner-statistics-preserved-on-major-version-upgrade",
"SourceKind": "yaml",
"SourceDatabase": "center",
"SourceTable": "featurematrix.yaml",
"SourceKey": "Planner statistics preserved on major version upgrade",
"SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
"Name": "Planner statistics preserved on major version upgrade",
"NameLocale": "en",
"GroupKey": "upgrade",
"GroupName": "Upgrade",
"GroupLocale": "en",
"Ordinal": 1,
"GroupOrder": 11,
"Facts": {
"feature": {
"description": "PostgreSQL now keeps planner statistics through a major version upgrade, which helps an upgraded cluster reach expected performance more quickly after the upgrade. See the statistics section in [`pg_upgrade`](https://www.postgresql.org/docs/18/pgupgrade.html) for more information.",
"name": "Planner statistics preserved on major version upgrade",
"versions": {
"18": "Yes"
}
},
"group": "Upgrade",
"versions": {
"max": 18,
"min": 8.1
}
},
"Cells": [
{
"Version": "10",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "11",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "12",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "13",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "14",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "15",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "16",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "17",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "18",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "18",
"Supported": true,
"Original": "Yes"
},
{
"Version": "8.1",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "8.2",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "8.3",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "8.4",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.0",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.1",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.2",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.3",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.4",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.5",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.6",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
}
],
"Texts": [
{
"Locale": "en",
"Title": "Planner statistics preserved on major version upgrade",
"BodyHTML": "\u003cp\u003ePostgreSQL now keeps planner statistics through a major version upgrade, which helps an upgraded cluster reach expected performance more quickly after the upgrade. See the statistics section in \u003ca href=\"https://www.postgresql.org/docs/18/pgupgrade.html\" rel=\"nofollow\"\u003e\u003ccode\u003epg_upgrade\u003c/code\u003e\u003c/a\u003e for more information.\u003c/p\u003e\n",
"SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
"ContentHash": "1f8e4545eeef9b706c7f6d51e3ee697c8ca9301a47482bee4e5863cb9408c3da",
"Payload": {
"description": "PostgreSQL now keeps planner statistics through a major version upgrade, which helps an upgraded cluster reach expected performance more quickly after the upgrade. See the statistics section in [`pg_upgrade`](https://www.postgresql.org/docs/18/pgupgrade.html) for more information.",
"name": "Planner statistics preserved on major version upgrade",
"versions": {
"18": "Yes"
}
}
},
{
"Locale": "zh-Hans",
"Title": "主版本升级后保留规划器统计信息",
"BodyHTML": "\u003cp\u003e主版本升级后会保留规划器统计信息，使集簇在升级完成后更快恢复预期性能。\u003c/p\u003e\n",
"SourceHash": "071091951021357a5f492adb04caed6febf4d315ac2626ca027a48dd8ec01d50",
"ContentHash": "257541fd850410c17567081284a7679d686170bfb6d3eca6ec69d526e942c6a5",
"Payload": {
"description": "主版本升级后会保留规划器统计信息，使集簇在升级完成后更快恢复预期性能。",
"name": "主版本升级后保留规划器统计信息"
}
}
],
"GroupTitles": {
"en": "Upgrade",
"zh-Hans": "升级"
}
}