{"kind": "storage", "major": "18", "item": {"slug": "storage-vm", "name": "Visibility Map", "name_zh": "", "category": "\u7269\u7406\u7ed3\u6784", "summary": "\u6bcf\u4e2a\u5806\u5173\u7cfb\u90fd\u6709\u4e00\u4e2a\u53ef\u89c1\u6027\u6620\u5c04\uff08VM\uff09\uff0c\u7528\u4e8e\u8ddf\u8e2a\u54ea\u4e9b\u9875\u9762\u53ea\u5305\u542b\u5df2\u77e5\u5bf9\u6240\u6709\u6d3b\u52a8\u4e8b\u52a1\u90fd\u53ef\u89c1\u7684\u5143\u7ec4\uff1b\u5b83\u8fd8\u4f1a\u8ddf\u8e2a\u54ea\u4e9b\u9875\u9762\u53ea\u5305\u542b\u5df2\u51bb\u7ed3\u7684\u5143\u7ec4\u3002\u5b83\u4e0e\u4e3b\u5173\u7cfb\u6570\u636e\u5e76\u5217\u5b58\u653e\u5728\u4e00\u4e2a\u72ec\u7acb\u7684\u5173\u7cfb\u5206\u652f\u4e2d\uff0c\u540d\u79f0\u7531\u5173\u7cfb\u7684\u6587\u4ef6\u8282\u70b9\u7f16\u53f7\u52a0\u4e0a _vm \u540e\u7f00\u6784\u6210\u3002\u4f8b\u5982\uff0c\u5982\u679c\u67d0\u5173\u7cfb\u7684\u6587\u4ef6\u8282\u70b9\u662f 12345\uff0c\u90a3\u4e48 VM \u4f1a\u5b58\u50a8\u5728\u540d\u4e3a 12345_vm \u7684\u6587\u4ef6\u4e2d\uff0c\u4e0e\u4e3b\u5173\u7cfb\u6587\u4ef6\u4f4d\u4e8e\u540c\u4e00\u76ee\u5f55\u3002\u8bf7\u6ce8\u610f\uff0c\u7d22\u5f15\u6ca1\u6709 VM\u3002", "aliases": [], "content_hash": "81604269d1dfd970aa2ba3a5ac27cd6fc703d695c165d3c9f0b2aef3f1593fed", "versions": {"10": {"facts": [{"label": "\u5b9a\u4e49\u8303\u56f4", "value": "\u540c\u7248\u672c\u6838\u5fc3\u7269\u7406\u5b58\u50a8\u6587\u6863"}], "tables": [], "related": [{"url": "/wiki/relopts/?v=10", "label": "\u5b58\u50a8\u53c2\u6570"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v10.23/postgresql-10.23.tar.bz2", "label": "10.23", "major": "10", "channel": "stable", "revision": "94a4b2528372458e5662c18d406629266667c437198160a18cdfd2c4a4d6eee9"}, "sources": [{"url": "https://pg.center/docs/10/storage-vm.html", "path": "storage-vm.html", "label": "PostgreSQL 10 English manual", "sha256": "5ec15a66fc48ed0b83c225f2edf1cb2a2c4aaeb669c584da2215199b1e08883c", "language": "en", "original_url": "/docs/10/storage-vm.html"}], "sections": [], "signature": "", "description": ["\u6bcf\u4e2a\u5806\u5173\u7cfb\u90fd\u6709\u4e00\u4e2a\u53ef\u89c1\u6027\u6620\u5c04\uff08VM\uff09\uff0c\u7528\u4e8e\u8ddf\u8e2a\u54ea\u4e9b\u9875\u9762\u53ea\u5305\u542b\u5df2\u77e5\u5bf9\u6240\u6709\u6d3b\u52a8\u4e8b\u52a1\u90fd\u53ef\u89c1\u7684\u5143\u7ec4\uff1b\u5b83\u8fd8\u4f1a\u8ddf\u8e2a\u54ea\u4e9b\u9875\u9762\u53ea\u5305\u542b\u5df2\u51bb\u7ed3\u7684\u5143\u7ec4\u3002\u5b83\u4e0e\u4e3b\u5173\u7cfb\u6570\u636e\u5e76\u5217\u5b58\u653e\u5728\u4e00\u4e2a\u72ec\u7acb\u7684\u5173\u7cfb\u5206\u652f\u4e2d\uff0c\u540d\u79f0\u7531\u5173\u7cfb\u7684\u6587\u4ef6\u8282\u70b9\u7f16\u53f7\u52a0\u4e0a _vm \u540e\u7f00\u6784\u6210\u3002\u4f8b\u5982\uff0c\u5982\u679c\u67d0\u5173\u7cfb\u7684\u6587\u4ef6\u8282\u70b9\u662f 12345\uff0c\u90a3\u4e48 VM \u4f1a\u5b58\u50a8\u5728\u540d\u4e3a 12345_vm \u7684\u6587\u4ef6\u4e2d\uff0c\u4e0e\u4e3b\u5173\u7cfb\u6587\u4ef6\u4f4d\u4e8e\u540c\u4e00\u76ee\u5f55\u3002\u8bf7\u6ce8\u610f\uff0c\u7d22\u5f15\u6ca1\u6709 VM\u3002"], "manual_html": "
\n
\n
\n
\n

\n
\n
\n

67.4.\u00a0\u53ef\u89c1\u6027\u6620\u5c04

\n
\n
\n

\n
\n
\n
\n

\u6bcf\u4e2a\u5806\u5173\u7cfb\u90fd\u6709\u4e00\u4e2a\u53ef\u89c1\u6027\u6620\u5c04\uff08VM\uff09\uff0c\u7528\u4e8e\u8ddf\u8e2a\u54ea\u4e9b\u9875\u9762\u53ea\u5305\u542b\u5df2\u77e5\u5bf9\u6240\u6709\u6d3b\u52a8\u4e8b\u52a1\u90fd\u53ef\u89c1\u7684\u5143\u7ec4\uff1b\u5b83\u8fd8\u4f1a\u8ddf\u8e2a\u54ea\u4e9b\u9875\u9762\u53ea\u5305\u542b\u5df2\u51bb\u7ed3\u7684\u5143\u7ec4\u3002\u5b83\u4e0e\u4e3b\u5173\u7cfb\u6570\u636e\u5e76\u5217\u5b58\u653e\u5728\u4e00\u4e2a\u72ec\u7acb\u7684\u5173\u7cfb\u5206\u652f\u4e2d\uff0c\u540d\u79f0\u7531\u5173\u7cfb\u7684\u6587\u4ef6\u8282\u70b9\u7f16\u53f7\u52a0\u4e0a _vm \u540e\u7f00\u6784\u6210\u3002\u4f8b\u5982\uff0c\u5982\u679c\u67d0\u5173\u7cfb\u7684\u6587\u4ef6\u8282\u70b9\u662f 12345\uff0c\u90a3\u4e48 VM \u4f1a\u5b58\u50a8\u5728\u540d\u4e3a 12345_vm \u7684\u6587\u4ef6\u4e2d\uff0c\u4e0e\u4e3b\u5173\u7cfb\u6587\u4ef6\u4f4d\u4e8e\u540c\u4e00\u76ee\u5f55\u3002\u8bf7\u6ce8\u610f\uff0c\u7d22\u5f15\u6ca1\u6709 VM\u3002

\n

\u53ef\u89c1\u6027\u6620\u5c04\u4e3a\u6bcf\u4e2a\u5806\u9875\u9762\u5b58\u50a8\u4e24\u4e2a\u4f4d\u3002\u7b2c\u4e00\u4f4d\u82e5\u88ab\u7f6e\u4f4d\uff0c\u8868\u793a\u8be5\u9875\u9762\u662f\u5168\u90e8\u53ef\u89c1\uff08all-visible\uff09\uff0c\u6362\u53e5\u8bdd\u8bf4\uff0c\u8be5\u9875\u9762\u4e0d\u5305\u542b\u4efb\u4f55\u9700\u8981\u88ab\u6e05\u7406\u7684\u5143\u7ec4\u3002\u8fd9\u4e9b\u4fe1\u606f\u8fd8\u53ef\u4ee5\u88ab\u4ec5\u7d22\u5f15\u626b\u63cf\u7528\u6765\u53ea\u4f9d\u636e\u7d22\u5f15\u5143\u7ec4\u56de\u7b54\u67e5\u8be2\u3002\u7b2c\u4e8c\u4f4d\u82e5\u88ab\u7f6e\u4f4d\uff0c\u5219\u8868\u793a\u9875\u9762\u4e0a\u7684\u6240\u6709\u5143\u7ec4\u90fd\u5df2\u7ecf\u88ab\u51bb\u7ed3\u3002\u8fd9\u610f\u5473\u7740\uff0c\u5373\u4f7f\u662f\u9632\u56de\u5377\u6e05\u7406\u4e5f\u4e0d\u5fc5\u91cd\u65b0\u8bbf\u95ee\u8be5\u9875\u9762\u3002

\n

\u8fd9\u4e2a\u6620\u5c04\u662f\u4fdd\u5b88\u7684\uff0c\u4e5f\u5c31\u662f\u8bf4\uff0c\u53ea\u8981\u67d0\u4e2a\u4f4d\u88ab\u7f6e\u4f4d\uff0c\u6211\u4eec\u5c31\u80fd\u786e\u5b9a\u76f8\u5e94\u6761\u4ef6\u786e\u5b9e\u6210\u7acb\uff1b\u4f46\u5982\u679c\u67d0\u4e2a\u4f4d\u6ca1\u6709\u7f6e\u4f4d\uff0c\u8be5\u6761\u4ef6\u65e2\u53ef\u80fd\u4e3a\u771f\uff0c\u4e5f\u53ef\u80fd\u4e0d\u4e3a\u771f\u3002\u53ef\u89c1\u6027\u6620\u5c04\u4f4d\u53ea\u4f1a\u7531 VACUUM \u8bbe\u7f6e\uff0c\u4f46\u9875\u9762\u4e0a\u7684\u4efb\u4f55\u6570\u636e\u4fee\u6539\u64cd\u4f5c\u90fd\u4f1a\u628a\u5b83\u4eec\u6e05\u9664\u3002

\n

pg_visibility\u6a21\u5757\u53ef\u7528\u4e8e\u68c0\u67e5\u53ef\u89c1\u6027\u6620\u5c04\u4e2d\u5b58\u50a8\u7684\u4fe1\u606f\u3002

\n
", "manual_path": "/docs/10/storage-vm.html", "localization": {"status": "complete", "sources": [{"url": "/docs/10/storage-vm.html", "method": "same-major semantic node", "sha256": "17ef11a1483a945b4b88dfd177d6e24cd49ef74082b8222004ac5e4874fd1332", "language": "zh", "matched_nodes": ["#STORAGE-VM/div[0]", "#STORAGE-VM/p[3]", "#STORAGE-VM/p[4]", "#STORAGE-VM/p[5]", "#STORAGE-VM/p[6]"]}], "language": "zh", "original_text": {"/versions/10/description/0": "Each heap relation has a Visibility Map (VM) to keep track of which pages contain only tuples that are known to be visible to all active transactions; it also keeps track of which pages contain only frozen tuples. It's stored alongside the main relation data in a separate relation fork, named after the filenode number of the relation, plus a _vm suffix. For example, if the filenode of a relation is 12345, the VM is stored in a file called 12345_vm , in the same directory as the main relation file. Note that indexes do not have VMs.", "/versions/10/facts/0/label": "Definition scope", "/versions/10/facts/0/value": "Same-version core physical storage documentation", "/versions/10/related/0/label": "Storage Parameters"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "bbf5e1c5e67ec0d4f0c4994a4f90c16ab017a3cdb0b57b763ba570db31f44a89"}, "comparison_data": {"layouts": []}, "comparison_hash": "27341929154bfb55531f03501322b65af719c5561f3c4ddc9528a14aa4df69b5", "manual_language": "zh"}, "11": {"facts": [{"label": "\u5b9a\u4e49\u8303\u56f4", "value": "\u540c\u7248\u672c\u6838\u5fc3\u7269\u7406\u5b58\u50a8\u6587\u6863"}], "tables": [], "related": [{"url": "/wiki/relopts/?v=11", "label": "\u5b58\u50a8\u53c2\u6570"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v11.22/postgresql-11.22.tar.bz2", "label": "11.22", "major": "11", "channel": "stable", "revision": "2cb7c97d7a0d7278851bbc9c61f467b69c094c72b81740b751108e7892ebe1f0"}, "sources": [{"url": "https://pg.center/docs/11/storage-vm.html", "path": "storage-vm.html", "label": "PostgreSQL 11 English manual", "sha256": "33770d778927a787f912334491a9215dd162549fba2b0b3a57a399238db07f6f", "language": "en", "original_url": "/docs/11/storage-vm.html"}], "sections": [], "signature": "", "description": ["\u6bcf\u4e2a\u5806\u5173\u7cfb\u90fd\u6709\u4e00\u4e2a\u53ef\u89c1\u6027\u6620\u5c04\uff08VM\uff09\uff0c\u7528\u4e8e\u8ddf\u8e2a\u54ea\u4e9b\u9875\u9762\u53ea\u5305\u542b\u5df2\u77e5\u5bf9\u6240\u6709\u6d3b\u52a8\u4e8b\u52a1\u90fd\u53ef\u89c1\u7684\u5143\u7ec4\uff1b\u5b83\u8fd8\u4f1a\u8ddf\u8e2a\u54ea\u4e9b\u9875\u9762\u53ea\u5305\u542b\u5df2\u51bb\u7ed3\u7684\u5143\u7ec4\u3002\u5b83\u4e0e\u4e3b\u5173\u7cfb\u6570\u636e\u5e76\u5217\u5b58\u653e\u5728\u4e00\u4e2a\u72ec\u7acb\u7684\u5173\u7cfb\u5206\u652f\u4e2d\uff0c\u540d\u79f0\u7531\u5173\u7cfb\u7684\u6587\u4ef6\u8282\u70b9\u7f16\u53f7\u52a0\u4e0a _vm \u540e\u7f00\u6784\u6210\u3002\u4f8b\u5982\uff0c\u5982\u679c\u67d0\u5173\u7cfb\u7684\u6587\u4ef6\u8282\u70b9\u662f 12345\uff0c\u90a3\u4e48 VM \u4f1a\u5b58\u50a8\u5728\u540d\u4e3a 12345_vm \u7684\u6587\u4ef6\u4e2d\uff0c\u4e0e\u4e3b\u5173\u7cfb\u6587\u4ef6\u4f4d\u4e8e\u540c\u4e00\u76ee\u5f55\u3002\u8bf7\u6ce8\u610f\uff0c\u7d22\u5f15\u6ca1\u6709 VM\u3002"], "manual_html": "
\n
\n
\n
\n

\n
\n
\n

69.4.\u00a0\u53ef\u89c1\u6027\u6620\u5c04

\n
\n
\n

\n
\n
\n
\n

\u6bcf\u4e2a\u5806\u5173\u7cfb\u90fd\u6709\u4e00\u4e2a\u53ef\u89c1\u6027\u6620\u5c04\uff08VM\uff09\uff0c\u7528\u4e8e\u8ddf\u8e2a\u54ea\u4e9b\u9875\u9762\u53ea\u5305\u542b\u5df2\u77e5\u5bf9\u6240\u6709\u6d3b\u52a8\u4e8b\u52a1\u90fd\u53ef\u89c1\u7684\u5143\u7ec4\uff1b\u5b83\u8fd8\u4f1a\u8ddf\u8e2a\u54ea\u4e9b\u9875\u9762\u53ea\u5305\u542b\u5df2\u51bb\u7ed3\u7684\u5143\u7ec4\u3002\u5b83\u4e0e\u4e3b\u5173\u7cfb\u6570\u636e\u5e76\u5217\u5b58\u653e\u5728\u4e00\u4e2a\u72ec\u7acb\u7684\u5173\u7cfb\u5206\u652f\u4e2d\uff0c\u540d\u79f0\u7531\u5173\u7cfb\u7684\u6587\u4ef6\u8282\u70b9\u7f16\u53f7\u52a0\u4e0a _vm \u540e\u7f00\u6784\u6210\u3002\u4f8b\u5982\uff0c\u5982\u679c\u67d0\u5173\u7cfb\u7684\u6587\u4ef6\u8282\u70b9\u662f 12345\uff0c\u90a3\u4e48 VM \u4f1a\u5b58\u50a8\u5728\u540d\u4e3a 12345_vm \u7684\u6587\u4ef6\u4e2d\uff0c\u4e0e\u4e3b\u5173\u7cfb\u6587\u4ef6\u4f4d\u4e8e\u540c\u4e00\u76ee\u5f55\u3002\u8bf7\u6ce8\u610f\uff0c\u7d22\u5f15\u6ca1\u6709 VM\u3002

\n

\u53ef\u89c1\u6027\u6620\u5c04\u4e3a\u6bcf\u4e2a\u5806\u9875\u9762\u5b58\u50a8\u4e24\u4e2a\u4f4d\u3002\u7b2c\u4e00\u4f4d\u82e5\u88ab\u7f6e\u4f4d\uff0c\u8868\u793a\u8be5\u9875\u9762\u662f\u5168\u90e8\u53ef\u89c1\uff08all-visible\uff09\uff0c\u6362\u53e5\u8bdd\u8bf4\uff0c\u8be5\u9875\u9762\u4e0d\u5305\u542b\u4efb\u4f55\u9700\u8981\u88ab\u6e05\u7406\u7684\u5143\u7ec4\u3002\u8fd9\u4e9b\u4fe1\u606f\u8fd8\u53ef\u4ee5\u88ab\u4ec5\u7d22\u5f15\u626b\u63cf\u7528\u6765\u53ea\u4f9d\u636e\u7d22\u5f15\u5143\u7ec4\u56de\u7b54\u67e5\u8be2\u3002\u7b2c\u4e8c\u4f4d\u82e5\u88ab\u7f6e\u4f4d\uff0c\u5219\u8868\u793a\u9875\u9762\u4e0a\u7684\u6240\u6709\u5143\u7ec4\u90fd\u5df2\u7ecf\u88ab\u51bb\u7ed3\u3002\u8fd9\u610f\u5473\u7740\uff0c\u5373\u4f7f\u662f\u9632\u56de\u5377\u6e05\u7406\u4e5f\u4e0d\u5fc5\u91cd\u65b0\u8bbf\u95ee\u8be5\u9875\u9762\u3002

\n

\u8fd9\u4e2a\u6620\u5c04\u662f\u4fdd\u5b88\u7684\uff0c\u4e5f\u5c31\u662f\u8bf4\uff0c\u53ea\u8981\u67d0\u4e2a\u4f4d\u88ab\u7f6e\u4f4d\uff0c\u6211\u4eec\u5c31\u80fd\u786e\u5b9a\u76f8\u5e94\u6761\u4ef6\u786e\u5b9e\u6210\u7acb\uff1b\u4f46\u5982\u679c\u67d0\u4e2a\u4f4d\u6ca1\u6709\u7f6e\u4f4d\uff0c\u8be5\u6761\u4ef6\u65e2\u53ef\u80fd\u4e3a\u771f\uff0c\u4e5f\u53ef\u80fd\u4e0d\u4e3a\u771f\u3002\u53ef\u89c1\u6027\u6620\u5c04\u4f4d\u53ea\u4f1a\u7531 VACUUM \u8bbe\u7f6e\uff0c\u4f46\u9875\u9762\u4e0a\u7684\u4efb\u4f55\u6570\u636e\u4fee\u6539\u64cd\u4f5c\u90fd\u4f1a\u628a\u5b83\u4eec\u6e05\u9664\u3002

\n

pg_visibility\u6a21\u5757\u53ef\u7528\u4e8e\u68c0\u67e5\u53ef\u89c1\u6027\u6620\u5c04\u4e2d\u5b58\u50a8\u7684\u4fe1\u606f\u3002

\n
", "manual_path": "/docs/11/storage-vm.html", "localization": {"status": "complete", "sources": [{"url": "/docs/11/storage-vm.html", "method": "same-major semantic node", "sha256": "24ce410c37a16d582a134bc3308735c2918bafa247b018f812fc02c880fba43a", "language": "zh", "matched_nodes": ["#STORAGE-VM/div[0]", "#STORAGE-VM/p[3]", "#STORAGE-VM/p[4]", "#STORAGE-VM/p[5]", "#STORAGE-VM/p[6]"]}], "language": "zh", "original_text": {"/versions/11/description/0": "Each heap relation has a Visibility Map (VM) to keep track of which pages contain only tuples that are known to be visible to all active transactions; it also keeps track of which pages contain only frozen tuples. It's stored alongside the main relation data in a separate relation fork, named after the filenode number of the relation, plus a _vm suffix. For example, if the filenode of a relation is 12345, the VM is stored in a file called 12345_vm , in the same directory as the main relation file. Note that indexes do not have VMs.", "/versions/11/facts/0/label": "Definition scope", "/versions/11/facts/0/value": "Same-version core physical storage documentation", "/versions/11/related/0/label": "Storage Parameters"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "99465dfc2411d5ddc7d747a0004e7a38fa7b7dc12ea563ae5f0b74942e830a3d"}, "comparison_data": {"layouts": []}, "comparison_hash": "27341929154bfb55531f03501322b65af719c5561f3c4ddc9528a14aa4df69b5", "manual_language": "zh"}, "12": {"facts": [{"label": "\u5b9a\u4e49\u8303\u56f4", "value": "\u540c\u7248\u672c\u6838\u5fc3\u7269\u7406\u5b58\u50a8\u6587\u6863"}], "tables": [], "related": [{"url": "/wiki/tableam/?v=12", "label": "Table AM"}, {"url": "/wiki/relopts/?v=12", "label": "\u5b58\u50a8\u53c2\u6570"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v12.22/postgresql-12.22.tar.bz2", "label": "12.22", "major": "12", "channel": "stable", "revision": "8df3c0474782589d3c6f374b5133b1bd14d168086edbc13c6e72e67dd4527a3b"}, "sources": [{"url": "https://pg.center/docs/12/storage-vm.html", "path": "storage-vm.html", "label": "PostgreSQL 12 English manual", "sha256": "7fd07c042febcfa5d93640af2a2af7cb1b40f55cd9d583eefa43826ddb4ef4b2", "language": "en", "original_url": "/docs/12/storage-vm.html"}], "sections": [], "signature": "", "description": ["\u6bcf\u4e2a\u5806\u5173\u7cfb\u90fd\u6709\u4e00\u4e2a\u53ef\u89c1\u6027\u6620\u5c04\uff08VM\uff09\uff0c\u7528\u4e8e\u8ddf\u8e2a\u54ea\u4e9b\u9875\u9762\u53ea\u5305\u542b\u5df2\u77e5\u5bf9\u6240\u6709\u6d3b\u52a8\u4e8b\u52a1\u90fd\u53ef\u89c1\u7684\u5143\u7ec4\uff1b\u5b83\u8fd8\u4f1a\u8ddf\u8e2a\u54ea\u4e9b\u9875\u9762\u53ea\u5305\u542b\u5df2\u51bb\u7ed3\u7684\u5143\u7ec4\u3002\u5b83\u4e0e\u4e3b\u5173\u7cfb\u6570\u636e\u5e76\u5217\u5b58\u653e\u5728\u4e00\u4e2a\u72ec\u7acb\u7684\u5173\u7cfb\u5206\u652f\u4e2d\uff0c\u540d\u79f0\u7531\u5173\u7cfb\u7684\u6587\u4ef6\u8282\u70b9\u7f16\u53f7\u52a0\u4e0a _vm \u540e\u7f00\u6784\u6210\u3002\u4f8b\u5982\uff0c\u5982\u679c\u67d0\u5173\u7cfb\u7684\u6587\u4ef6\u8282\u70b9\u662f 12345\uff0c\u90a3\u4e48 VM \u4f1a\u5b58\u50a8\u5728\u540d\u4e3a 12345_vm \u7684\u6587\u4ef6\u4e2d\uff0c\u4e0e\u4e3b\u5173\u7cfb\u6587\u4ef6\u4f4d\u4e8e\u540c\u4e00\u76ee\u5f55\u3002\u8bf7\u6ce8\u610f\uff0c\u7d22\u5f15\u6ca1\u6709 VM\u3002"], "manual_html": "
\n
\n
\n
\n

\n
\n
\n

69.4.\u00a0\u53ef\u89c1\u6027\u6620\u5c04

\n
\n
\n

\n
\n
\n
\n

\u6bcf\u4e2a\u5806\u5173\u7cfb\u90fd\u6709\u4e00\u4e2a\u53ef\u89c1\u6027\u6620\u5c04\uff08VM\uff09\uff0c\u7528\u4e8e\u8ddf\u8e2a\u54ea\u4e9b\u9875\u9762\u53ea\u5305\u542b\u5df2\u77e5\u5bf9\u6240\u6709\u6d3b\u52a8\u4e8b\u52a1\u90fd\u53ef\u89c1\u7684\u5143\u7ec4\uff1b\u5b83\u8fd8\u4f1a\u8ddf\u8e2a\u54ea\u4e9b\u9875\u9762\u53ea\u5305\u542b\u5df2\u51bb\u7ed3\u7684\u5143\u7ec4\u3002\u5b83\u4e0e\u4e3b\u5173\u7cfb\u6570\u636e\u5e76\u5217\u5b58\u653e\u5728\u4e00\u4e2a\u72ec\u7acb\u7684\u5173\u7cfb\u5206\u652f\u4e2d\uff0c\u540d\u79f0\u7531\u5173\u7cfb\u7684\u6587\u4ef6\u8282\u70b9\u7f16\u53f7\u52a0\u4e0a _vm \u540e\u7f00\u6784\u6210\u3002\u4f8b\u5982\uff0c\u5982\u679c\u67d0\u5173\u7cfb\u7684\u6587\u4ef6\u8282\u70b9\u662f 12345\uff0c\u90a3\u4e48 VM \u4f1a\u5b58\u50a8\u5728\u540d\u4e3a 12345_vm \u7684\u6587\u4ef6\u4e2d\uff0c\u4e0e\u4e3b\u5173\u7cfb\u6587\u4ef6\u4f4d\u4e8e\u540c\u4e00\u76ee\u5f55\u3002\u8bf7\u6ce8\u610f\uff0c\u7d22\u5f15\u6ca1\u6709 VM\u3002

\n

\u53ef\u89c1\u6027\u6620\u5c04\u4e3a\u6bcf\u4e2a\u5806\u9875\u9762\u5b58\u50a8\u4e24\u4e2a\u4f4d\u3002\u7b2c\u4e00\u4f4d\u82e5\u88ab\u7f6e\u4f4d\uff0c\u8868\u793a\u8be5\u9875\u9762\u662f\u5168\u90e8\u53ef\u89c1\uff08all-visible\uff09\uff0c\u6362\u53e5\u8bdd\u8bf4\uff0c\u8be5\u9875\u9762\u4e0d\u5305\u542b\u4efb\u4f55\u9700\u8981\u88ab\u6e05\u7406\u7684\u5143\u7ec4\u3002\u8fd9\u4e9b\u4fe1\u606f\u8fd8\u53ef\u4ee5\u88ab\u4ec5\u7d22\u5f15\u626b\u63cf\u7528\u6765\u53ea\u4f9d\u636e\u7d22\u5f15\u5143\u7ec4\u56de\u7b54\u67e5\u8be2\u3002\u7b2c\u4e8c\u4f4d\u82e5\u88ab\u7f6e\u4f4d\uff0c\u5219\u8868\u793a\u9875\u9762\u4e0a\u7684\u6240\u6709\u5143\u7ec4\u90fd\u5df2\u7ecf\u88ab\u51bb\u7ed3\u3002\u8fd9\u610f\u5473\u7740\uff0c\u5373\u4f7f\u662f\u9632\u56de\u5377\u6e05\u7406\u4e5f\u4e0d\u5fc5\u91cd\u65b0\u8bbf\u95ee\u8be5\u9875\u9762\u3002

\n

\u8fd9\u4e2a\u6620\u5c04\u662f\u4fdd\u5b88\u7684\uff0c\u4e5f\u5c31\u662f\u8bf4\uff0c\u53ea\u8981\u67d0\u4e2a\u4f4d\u88ab\u7f6e\u4f4d\uff0c\u6211\u4eec\u5c31\u80fd\u786e\u5b9a\u76f8\u5e94\u6761\u4ef6\u786e\u5b9e\u6210\u7acb\uff1b\u4f46\u5982\u679c\u67d0\u4e2a\u4f4d\u6ca1\u6709\u7f6e\u4f4d\uff0c\u8be5\u6761\u4ef6\u65e2\u53ef\u80fd\u4e3a\u771f\uff0c\u4e5f\u53ef\u80fd\u4e0d\u4e3a\u771f\u3002\u53ef\u89c1\u6027\u6620\u5c04\u4f4d\u53ea\u4f1a\u7531 VACUUM \u8bbe\u7f6e\uff0c\u4f46\u9875\u9762\u4e0a\u7684\u4efb\u4f55\u6570\u636e\u4fee\u6539\u64cd\u4f5c\u90fd\u4f1a\u628a\u5b83\u4eec\u6e05\u9664\u3002

\n

pg_visibility\u6a21\u5757\u53ef\u7528\u4e8e\u68c0\u67e5\u53ef\u89c1\u6027\u6620\u5c04\u4e2d\u5b58\u50a8\u7684\u4fe1\u606f\u3002

\n
", "manual_path": "/docs/12/storage-vm.html", "localization": {"status": "complete", "sources": [{"url": "/docs/12/storage-vm.html", "method": "same-major semantic node", "sha256": "7355500e9e8bbe337e38a45f1f7d4e10b367e999dcad45ebd040d0584ed56974", "language": "zh", "matched_nodes": ["#STORAGE-VM/div[0]", "#STORAGE-VM/p[3]", "#STORAGE-VM/p[4]", "#STORAGE-VM/p[5]", "#STORAGE-VM/p[6]"]}], "language": "zh", "original_text": {"/versions/12/description/0": "Each heap relation has a Visibility Map (VM) to keep track of which pages contain only tuples that are known to be visible to all active transactions; it also keeps track of which pages contain only frozen tuples. It's stored alongside the main relation data in a separate relation fork, named after the filenode number of the relation, plus a _vm suffix. For example, if the filenode of a relation is 12345, the VM is stored in a file called 12345_vm , in the same directory as the main relation file. Note that indexes do not have VMs.", "/versions/12/facts/0/label": "Definition scope", "/versions/12/facts/0/value": "Same-version core physical storage documentation", "/versions/12/related/1/label": "Storage Parameters"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "d8af0ad3c26cbb88457f2def5dce009255692c58dd07b82479f4b098a000b4e2"}, "comparison_data": {"layouts": []}, "comparison_hash": "27341929154bfb55531f03501322b65af719c5561f3c4ddc9528a14aa4df69b5", "manual_language": "zh"}, "13": {"facts": [{"label": "\u5b9a\u4e49\u8303\u56f4", "value": "\u540c\u7248\u672c\u6838\u5fc3\u7269\u7406\u5b58\u50a8\u6587\u6863"}], "tables": [], "related": [{"url": "/wiki/tableam/?v=13", "label": "Table AM"}, {"url": "/wiki/relopts/?v=13", "label": "\u5b58\u50a8\u53c2\u6570"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v13.23/postgresql-13.23.tar.bz2", "label": "13.23", "major": "13", "channel": "stable", "revision": "6ec3c82726af92b7dec873fa1cdf881eca92a4219787dfad05acb6b10e041fd6"}, "sources": [{"url": "https://pg.center/docs/13/storage-vm.html", "path": "storage-vm.html", "label": "PostgreSQL 13 English manual", "sha256": "97ed3081308ea3b5ee3e8a7233d0785ae794a45d0113f0c326805fd4b5064778", "language": "en", "original_url": "/docs/13/storage-vm.html"}], "sections": [], "signature": "", "description": ["\u6bcf\u4e2a\u5806\u5173\u7cfb\u90fd\u6709\u4e00\u4e2a\u53ef\u89c1\u6027\u6620\u5c04\uff08VM\uff09\uff0c\u7528\u4e8e\u8ddf\u8e2a\u54ea\u4e9b\u9875\u9762\u53ea\u5305\u542b\u5df2\u77e5\u5bf9\u6240\u6709\u6d3b\u52a8\u4e8b\u52a1\u90fd\u53ef\u89c1\u7684\u5143\u7ec4\uff1b\u5b83\u8fd8\u4f1a\u8ddf\u8e2a\u54ea\u4e9b\u9875\u9762\u53ea\u5305\u542b\u5df2\u51bb\u7ed3\u7684\u5143\u7ec4\u3002\u5b83\u4e0e\u4e3b\u5173\u7cfb\u6570\u636e\u5e76\u5217\u5b58\u653e\u5728\u4e00\u4e2a\u72ec\u7acb\u7684\u5173\u7cfb\u5206\u652f\u4e2d\uff0c\u540d\u79f0\u7531\u5173\u7cfb\u7684\u6587\u4ef6\u8282\u70b9\u7f16\u53f7\u52a0\u4e0a _vm \u540e\u7f00\u6784\u6210\u3002\u4f8b\u5982\uff0c\u5982\u679c\u67d0\u5173\u7cfb\u7684\u6587\u4ef6\u8282\u70b9\u662f 12345\uff0c\u90a3\u4e48 VM \u4f1a\u5b58\u50a8\u5728\u540d\u4e3a 12345_vm \u7684\u6587\u4ef6\u4e2d\uff0c\u4e0e\u4e3b\u5173\u7cfb\u6587\u4ef6\u4f4d\u4e8e\u540c\u4e00\u76ee\u5f55\u3002\u8bf7\u6ce8\u610f\uff0c\u7d22\u5f15\u6ca1\u6709 VM\u3002"], "manual_html": "
\n
\n
\n
\n

\n
\n
\n

69.4.\u00a0\u53ef\u89c1\u6027\u6620\u5c04

\n
\n
\n

\n
\n
\n
\n

\u6bcf\u4e2a\u5806\u5173\u7cfb\u90fd\u6709\u4e00\u4e2a\u53ef\u89c1\u6027\u6620\u5c04\uff08VM\uff09\uff0c\u7528\u4e8e\u8ddf\u8e2a\u54ea\u4e9b\u9875\u9762\u53ea\u5305\u542b\u5df2\u77e5\u5bf9\u6240\u6709\u6d3b\u52a8\u4e8b\u52a1\u90fd\u53ef\u89c1\u7684\u5143\u7ec4\uff1b\u5b83\u8fd8\u4f1a\u8ddf\u8e2a\u54ea\u4e9b\u9875\u9762\u53ea\u5305\u542b\u5df2\u51bb\u7ed3\u7684\u5143\u7ec4\u3002\u5b83\u4e0e\u4e3b\u5173\u7cfb\u6570\u636e\u5e76\u5217\u5b58\u653e\u5728\u4e00\u4e2a\u72ec\u7acb\u7684\u5173\u7cfb\u5206\u652f\u4e2d\uff0c\u540d\u79f0\u7531\u5173\u7cfb\u7684\u6587\u4ef6\u8282\u70b9\u7f16\u53f7\u52a0\u4e0a _vm \u540e\u7f00\u6784\u6210\u3002\u4f8b\u5982\uff0c\u5982\u679c\u67d0\u5173\u7cfb\u7684\u6587\u4ef6\u8282\u70b9\u662f 12345\uff0c\u90a3\u4e48 VM \u4f1a\u5b58\u50a8\u5728\u540d\u4e3a 12345_vm \u7684\u6587\u4ef6\u4e2d\uff0c\u4e0e\u4e3b\u5173\u7cfb\u6587\u4ef6\u4f4d\u4e8e\u540c\u4e00\u76ee\u5f55\u3002\u8bf7\u6ce8\u610f\uff0c\u7d22\u5f15\u6ca1\u6709 VM\u3002

\n

\u53ef\u89c1\u6027\u6620\u5c04\u4e3a\u6bcf\u4e2a\u5806\u9875\u9762\u5b58\u50a8\u4e24\u4e2a\u4f4d\u3002\u7b2c\u4e00\u4f4d\u82e5\u88ab\u7f6e\u4f4d\uff0c\u8868\u793a\u8be5\u9875\u9762\u662f\u5168\u90e8\u53ef\u89c1\uff08all-visible\uff09\uff0c\u6362\u53e5\u8bdd\u8bf4\uff0c\u8be5\u9875\u9762\u4e0d\u5305\u542b\u4efb\u4f55\u9700\u8981\u88ab\u6e05\u7406\u7684\u5143\u7ec4\u3002\u8fd9\u4e9b\u4fe1\u606f\u8fd8\u53ef\u4ee5\u88ab\u4ec5\u7d22\u5f15\u626b\u63cf\u7528\u6765\u53ea\u4f9d\u636e\u7d22\u5f15\u5143\u7ec4\u56de\u7b54\u67e5\u8be2\u3002\u7b2c\u4e8c\u4f4d\u82e5\u88ab\u7f6e\u4f4d\uff0c\u5219\u8868\u793a\u9875\u9762\u4e0a\u7684\u6240\u6709\u5143\u7ec4\u90fd\u5df2\u7ecf\u88ab\u51bb\u7ed3\u3002\u8fd9\u610f\u5473\u7740\uff0c\u5373\u4f7f\u662f\u9632\u56de\u5377\u6e05\u7406\u4e5f\u4e0d\u5fc5\u91cd\u65b0\u8bbf\u95ee\u8be5\u9875\u9762\u3002

\n

\u8fd9\u4e2a\u6620\u5c04\u662f\u4fdd\u5b88\u7684\uff0c\u4e5f\u5c31\u662f\u8bf4\uff0c\u53ea\u8981\u67d0\u4e2a\u4f4d\u88ab\u7f6e\u4f4d\uff0c\u6211\u4eec\u5c31\u80fd\u786e\u5b9a\u76f8\u5e94\u6761\u4ef6\u786e\u5b9e\u6210\u7acb\uff1b\u4f46\u5982\u679c\u67d0\u4e2a\u4f4d\u6ca1\u6709\u7f6e\u4f4d\uff0c\u8be5\u6761\u4ef6\u65e2\u53ef\u80fd\u4e3a\u771f\uff0c\u4e5f\u53ef\u80fd\u4e0d\u4e3a\u771f\u3002\u53ef\u89c1\u6027\u6620\u5c04\u4f4d\u53ea\u4f1a\u7531 VACUUM \u8bbe\u7f6e\uff0c\u4f46\u9875\u9762\u4e0a\u7684\u4efb\u4f55\u6570\u636e\u4fee\u6539\u64cd\u4f5c\u90fd\u4f1a\u628a\u5b83\u4eec\u6e05\u9664\u3002

\n

pg_visibility\u6a21\u5757\u53ef\u7528\u4e8e\u68c0\u67e5\u53ef\u89c1\u6027\u6620\u5c04\u4e2d\u5b58\u50a8\u7684\u4fe1\u606f\u3002

\n
", "manual_path": "/docs/13/storage-vm.html", "localization": {"status": "complete", "sources": [{"url": "/docs/13/storage-vm.html", "method": "same-major semantic node", "sha256": "d2f188abdb70f74f21ef317940c1807263e14f6ae23a7eac264bd0b0726382fc", "language": "zh", "matched_nodes": ["#STORAGE-VM/div[0]", "#STORAGE-VM/p[3]", "#STORAGE-VM/p[4]", "#STORAGE-VM/p[5]", "#STORAGE-VM/p[6]"]}], "language": "zh", "original_text": {"/versions/13/description/0": "Each heap relation has a Visibility Map (VM) to keep track of which pages contain only tuples that are known to be visible to all active transactions; it also keeps track of which pages contain only frozen tuples. It's stored alongside the main relation data in a separate relation fork, named after the filenode number of the relation, plus a _vm suffix. For example, if the filenode of a relation is 12345, the VM is stored in a file called 12345_vm , in the same directory as the main relation file. Note that indexes do not have VMs.", "/versions/13/facts/0/label": "Definition scope", "/versions/13/facts/0/value": "Same-version core physical storage documentation", "/versions/13/related/1/label": "Storage Parameters"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "19b0019c806ee4295b07f17f778d001a7cc801a5062122624ab4e13b56123679"}, "comparison_data": {"layouts": []}, "comparison_hash": "27341929154bfb55531f03501322b65af719c5561f3c4ddc9528a14aa4df69b5", "manual_language": "zh"}, "14": {"facts": [{"label": "\u5b9a\u4e49\u8303\u56f4", "value": "\u540c\u7248\u672c\u6838\u5fc3\u7269\u7406\u5b58\u50a8\u6587\u6863"}], "tables": [], "related": [{"url": "/wiki/tableam/?v=14", "label": "Table AM"}, {"url": "/wiki/relopts/?v=14", "label": "\u5b58\u50a8\u53c2\u6570"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v14.24/postgresql-14.24.tar.bz2", "label": "14.24", "major": "14", "channel": "stable", "revision": "a7fa7ed3d558172355f51406097a7bd4f6b473be80f311ef7cda96bf383d8897"}, "sources": [{"url": "https://pg.center/docs/14/storage-vm.html", "path": "storage-vm.html", "label": "PostgreSQL 14 English manual", "sha256": "e5ef57e0c0e252b6aea29d1094a8c4f73755c2e43d715559c6b2bd18f6e7dcaf", "language": "en", "original_url": "/docs/14/storage-vm.html"}], "sections": [], "signature": "", "description": ["\u6bcf\u4e2a\u5806\u5173\u7cfb\u90fd\u6709\u4e00\u4e2a\u53ef\u89c1\u6027\u6620\u5c04\uff08VM\uff09\uff0c\u7528\u4e8e\u8ddf\u8e2a\u54ea\u4e9b\u9875\u9762\u53ea\u5305\u542b\u5df2\u77e5\u5bf9\u6240\u6709\u6d3b\u52a8\u4e8b\u52a1\u90fd\u53ef\u89c1\u7684\u5143\u7ec4\uff1b\u5b83\u8fd8\u4f1a\u8ddf\u8e2a\u54ea\u4e9b\u9875\u9762\u53ea\u5305\u542b\u5df2\u51bb\u7ed3\u7684\u5143\u7ec4\u3002\u5b83\u4e0e\u4e3b\u5173\u7cfb\u6570\u636e\u5e76\u5217\u5b58\u653e\u5728\u4e00\u4e2a\u72ec\u7acb\u7684\u5173\u7cfb\u5206\u652f\u4e2d\uff0c\u540d\u79f0\u7531\u5173\u7cfb\u7684\u6587\u4ef6\u8282\u70b9\u7f16\u53f7\u52a0\u4e0a _vm \u540e\u7f00\u6784\u6210\u3002\u4f8b\u5982\uff0c\u5982\u679c\u67d0\u5173\u7cfb\u7684\u6587\u4ef6\u8282\u70b9\u662f 12345\uff0c\u90a3\u4e48 VM \u4f1a\u5b58\u50a8\u5728\u540d\u4e3a 12345_vm \u7684\u6587\u4ef6\u4e2d\uff0c\u4e0e\u4e3b\u5173\u7cfb\u6587\u4ef6\u4f4d\u4e8e\u540c\u4e00\u76ee\u5f55\u3002\u8bf7\u6ce8\u610f\uff0c\u7d22\u5f15\u6ca1\u6709 VM\u3002"], "manual_html": "
\n
\n
\n
\n

\n
\n
\n

70.4.\u00a0\u53ef\u89c1\u6027\u6620\u5c04

\n
\n
\n

\n
\n
\n
\n

\u6bcf\u4e2a\u5806\u5173\u7cfb\u90fd\u6709\u4e00\u4e2a\u53ef\u89c1\u6027\u6620\u5c04\uff08VM\uff09\uff0c\u7528\u4e8e\u8ddf\u8e2a\u54ea\u4e9b\u9875\u9762\u53ea\u5305\u542b\u5df2\u77e5\u5bf9\u6240\u6709\u6d3b\u52a8\u4e8b\u52a1\u90fd\u53ef\u89c1\u7684\u5143\u7ec4\uff1b\u5b83\u8fd8\u4f1a\u8ddf\u8e2a\u54ea\u4e9b\u9875\u9762\u53ea\u5305\u542b\u5df2\u51bb\u7ed3\u7684\u5143\u7ec4\u3002\u5b83\u4e0e\u4e3b\u5173\u7cfb\u6570\u636e\u5e76\u5217\u5b58\u653e\u5728\u4e00\u4e2a\u72ec\u7acb\u7684\u5173\u7cfb\u5206\u652f\u4e2d\uff0c\u540d\u79f0\u7531\u5173\u7cfb\u7684\u6587\u4ef6\u8282\u70b9\u7f16\u53f7\u52a0\u4e0a _vm \u540e\u7f00\u6784\u6210\u3002\u4f8b\u5982\uff0c\u5982\u679c\u67d0\u5173\u7cfb\u7684\u6587\u4ef6\u8282\u70b9\u662f 12345\uff0c\u90a3\u4e48 VM \u4f1a\u5b58\u50a8\u5728\u540d\u4e3a 12345_vm \u7684\u6587\u4ef6\u4e2d\uff0c\u4e0e\u4e3b\u5173\u7cfb\u6587\u4ef6\u4f4d\u4e8e\u540c\u4e00\u76ee\u5f55\u3002\u8bf7\u6ce8\u610f\uff0c\u7d22\u5f15\u6ca1\u6709 VM\u3002

\n

\u53ef\u89c1\u6027\u6620\u5c04\u4e3a\u6bcf\u4e2a\u5806\u9875\u9762\u5b58\u50a8\u4e24\u4e2a\u4f4d\u3002\u7b2c\u4e00\u4f4d\u82e5\u88ab\u7f6e\u4f4d\uff0c\u8868\u793a\u8be5\u9875\u9762\u662f\u5168\u90e8\u53ef\u89c1\uff08all-visible\uff09\uff0c\u6362\u53e5\u8bdd\u8bf4\uff0c\u8be5\u9875\u9762\u4e0d\u5305\u542b\u4efb\u4f55\u9700\u8981\u88ab\u6e05\u7406\u7684\u5143\u7ec4\u3002\u8fd9\u4e9b\u4fe1\u606f\u8fd8\u53ef\u4ee5\u88ab\u4ec5\u7d22\u5f15\u626b\u63cf\u7528\u6765\u53ea\u4f9d\u636e\u7d22\u5f15\u5143\u7ec4\u56de\u7b54\u67e5\u8be2\u3002\u7b2c\u4e8c\u4f4d\u82e5\u88ab\u7f6e\u4f4d\uff0c\u5219\u8868\u793a\u9875\u9762\u4e0a\u7684\u6240\u6709\u5143\u7ec4\u90fd\u5df2\u7ecf\u88ab\u51bb\u7ed3\u3002\u8fd9\u610f\u5473\u7740\uff0c\u5373\u4f7f\u662f\u9632\u56de\u5377\u6e05\u7406\u4e5f\u4e0d\u5fc5\u91cd\u65b0\u8bbf\u95ee\u8be5\u9875\u9762\u3002

\n

\u8fd9\u4e2a\u6620\u5c04\u662f\u4fdd\u5b88\u7684\uff0c\u4e5f\u5c31\u662f\u8bf4\uff0c\u53ea\u8981\u67d0\u4e2a\u4f4d\u88ab\u7f6e\u4f4d\uff0c\u6211\u4eec\u5c31\u80fd\u786e\u5b9a\u76f8\u5e94\u6761\u4ef6\u786e\u5b9e\u6210\u7acb\uff1b\u4f46\u5982\u679c\u67d0\u4e2a\u4f4d\u6ca1\u6709\u7f6e\u4f4d\uff0c\u8be5\u6761\u4ef6\u65e2\u53ef\u80fd\u4e3a\u771f\uff0c\u4e5f\u53ef\u80fd\u4e0d\u4e3a\u771f\u3002\u53ef\u89c1\u6027\u6620\u5c04\u4f4d\u53ea\u4f1a\u7531 VACUUM \u8bbe\u7f6e\uff0c\u4f46\u9875\u9762\u4e0a\u7684\u4efb\u4f55\u6570\u636e\u4fee\u6539\u64cd\u4f5c\u90fd\u4f1a\u628a\u5b83\u4eec\u6e05\u9664\u3002

\n

pg_visibility\u6a21\u5757\u53ef\u7528\u4e8e\u68c0\u67e5\u53ef\u89c1\u6027\u6620\u5c04\u4e2d\u5b58\u50a8\u7684\u4fe1\u606f\u3002

\n
", "manual_path": "/docs/14/storage-vm.html", "localization": {"status": "complete", "sources": [{"url": "/docs/14/storage-vm.html", "method": "same-major semantic node", "sha256": "9da3b5917c90fecebefbbc9d03583e485be6a8f0af1250510a7480b87c1e64e7", "language": "zh", "matched_nodes": ["#STORAGE-VM/div[0]", "#STORAGE-VM/p[3]", "#STORAGE-VM/p[4]", "#STORAGE-VM/p[5]", "#STORAGE-VM/p[6]"]}], "language": "zh", "original_text": {"/versions/14/description/0": "Each heap relation has a Visibility Map (VM) to keep track of which pages contain only tuples that are known to be visible to all active transactions; it also keeps track of which pages contain only frozen tuples. It's stored alongside the main relation data in a separate relation fork, named after the filenode number of the relation, plus a _vm suffix. For example, if the filenode of a relation is 12345, the VM is stored in a file called 12345_vm , in the same directory as the main relation file. Note that indexes do not have VMs.", "/versions/14/facts/0/label": "Definition scope", "/versions/14/facts/0/value": "Same-version core physical storage documentation", "/versions/14/related/1/label": "Storage Parameters"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "66f3e0642498fa47830a0759f801b5e2739724cee6c246f7078cb4b60855e0e0"}, "comparison_data": {"layouts": []}, "comparison_hash": "27341929154bfb55531f03501322b65af719c5561f3c4ddc9528a14aa4df69b5", "manual_language": "zh"}, "15": {"facts": [{"label": "\u5b9a\u4e49\u8303\u56f4", "value": "\u540c\u7248\u672c\u6838\u5fc3\u7269\u7406\u5b58\u50a8\u6587\u6863"}], "tables": [], "related": [{"url": "/wiki/tableam/?v=15", "label": "Table AM"}, {"url": "/wiki/relopts/?v=15", "label": "\u5b58\u50a8\u53c2\u6570"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v15.19/postgresql-15.19.tar.bz2", "label": "15.19", "major": "15", "channel": "stable", "revision": "e1a64a87a46b825b88c082e4518161a47aab53c45694964f8ba1df28f7859f89"}, "sources": [{"url": "https://pg.center/docs/15/storage-vm.html", "path": "storage-vm.html", "label": "PostgreSQL 15 English manual", "sha256": "959bbe7dff19332835bb8c73580ad9fbfa3acf51b47613ace97eb2e95a725194", "language": "en", "original_url": "/docs/15/storage-vm.html"}], "sections": [], "signature": "", "description": ["\u6bcf\u4e2a\u5806\u5173\u7cfb\u90fd\u6709\u4e00\u4e2a\u53ef\u89c1\u6027\u6620\u5c04\uff08VM\uff09\uff0c\u7528\u4e8e\u8ddf\u8e2a\u54ea\u4e9b\u9875\u9762\u53ea\u5305\u542b\u5df2\u77e5\u5bf9\u6240\u6709\u6d3b\u52a8\u4e8b\u52a1\u90fd\u53ef\u89c1\u7684\u5143\u7ec4\uff1b\u5b83\u8fd8\u4f1a\u8ddf\u8e2a\u54ea\u4e9b\u9875\u9762\u53ea\u5305\u542b\u5df2\u51bb\u7ed3\u7684\u5143\u7ec4\u3002\u5b83\u4e0e\u4e3b\u5173\u7cfb\u6570\u636e\u5e76\u5217\u5b58\u653e\u5728\u4e00\u4e2a\u72ec\u7acb\u7684\u5173\u7cfb\u5206\u652f\u4e2d\uff0c\u540d\u79f0\u7531\u5173\u7cfb\u7684\u6587\u4ef6\u8282\u70b9\u7f16\u53f7\u52a0\u4e0a _vm \u540e\u7f00\u6784\u6210\u3002\u4f8b\u5982\uff0c\u5982\u679c\u67d0\u5173\u7cfb\u7684\u6587\u4ef6\u8282\u70b9\u662f 12345\uff0c\u90a3\u4e48 VM \u4f1a\u5b58\u50a8\u5728\u540d\u4e3a 12345_vm \u7684\u6587\u4ef6\u4e2d\uff0c\u4e0e\u4e3b\u5173\u7cfb\u6587\u4ef6\u4f4d\u4e8e\u540c\u4e00\u76ee\u5f55\u3002\u8bf7\u6ce8\u610f\uff0c\u7d22\u5f15\u6ca1\u6709 VM\u3002"], "manual_html": "
\n
\n
\n
\n

\n
\n
\n

73.4.\u00a0\u53ef\u89c1\u6027\u6620\u5c04

\n
\n
\n

\n
\n
\n
\n

\u6bcf\u4e2a\u5806\u5173\u7cfb\u90fd\u6709\u4e00\u4e2a\u53ef\u89c1\u6027\u6620\u5c04\uff08VM\uff09\uff0c\u7528\u4e8e\u8ddf\u8e2a\u54ea\u4e9b\u9875\u9762\u53ea\u5305\u542b\u5df2\u77e5\u5bf9\u6240\u6709\u6d3b\u52a8\u4e8b\u52a1\u90fd\u53ef\u89c1\u7684\u5143\u7ec4\uff1b\u5b83\u8fd8\u4f1a\u8ddf\u8e2a\u54ea\u4e9b\u9875\u9762\u53ea\u5305\u542b\u5df2\u51bb\u7ed3\u7684\u5143\u7ec4\u3002\u5b83\u4e0e\u4e3b\u5173\u7cfb\u6570\u636e\u5e76\u5217\u5b58\u653e\u5728\u4e00\u4e2a\u72ec\u7acb\u7684\u5173\u7cfb\u5206\u652f\u4e2d\uff0c\u540d\u79f0\u7531\u5173\u7cfb\u7684\u6587\u4ef6\u8282\u70b9\u7f16\u53f7\u52a0\u4e0a _vm \u540e\u7f00\u6784\u6210\u3002\u4f8b\u5982\uff0c\u5982\u679c\u67d0\u5173\u7cfb\u7684\u6587\u4ef6\u8282\u70b9\u662f 12345\uff0c\u90a3\u4e48 VM \u4f1a\u5b58\u50a8\u5728\u540d\u4e3a 12345_vm \u7684\u6587\u4ef6\u4e2d\uff0c\u4e0e\u4e3b\u5173\u7cfb\u6587\u4ef6\u4f4d\u4e8e\u540c\u4e00\u76ee\u5f55\u3002\u8bf7\u6ce8\u610f\uff0c\u7d22\u5f15\u6ca1\u6709 VM\u3002

\n

\u53ef\u89c1\u6027\u6620\u5c04\u4e3a\u6bcf\u4e2a\u5806\u9875\u9762\u5b58\u50a8\u4e24\u4e2a\u4f4d\u3002\u7b2c\u4e00\u4f4d\u82e5\u88ab\u7f6e\u4f4d\uff0c\u8868\u793a\u8be5\u9875\u9762\u662f\u5168\u90e8\u53ef\u89c1\uff08all-visible\uff09\uff0c\u6362\u53e5\u8bdd\u8bf4\uff0c\u8be5\u9875\u9762\u4e0d\u5305\u542b\u4efb\u4f55\u9700\u8981\u88ab\u6e05\u7406\u7684\u5143\u7ec4\u3002\u8fd9\u4e9b\u4fe1\u606f\u8fd8\u53ef\u4ee5\u88ab\u4ec5\u7d22\u5f15\u626b\u63cf\u7528\u6765\u53ea\u4f9d\u636e\u7d22\u5f15\u5143\u7ec4\u56de\u7b54\u67e5\u8be2\u3002\u7b2c\u4e8c\u4f4d\u82e5\u88ab\u7f6e\u4f4d\uff0c\u5219\u8868\u793a\u9875\u9762\u4e0a\u7684\u6240\u6709\u5143\u7ec4\u90fd\u5df2\u7ecf\u88ab\u51bb\u7ed3\u3002\u8fd9\u610f\u5473\u7740\uff0c\u5373\u4f7f\u662f\u9632\u56de\u5377\u6e05\u7406\u4e5f\u4e0d\u5fc5\u91cd\u65b0\u8bbf\u95ee\u8be5\u9875\u9762\u3002

\n

\u8fd9\u4e2a\u6620\u5c04\u662f\u4fdd\u5b88\u7684\uff0c\u4e5f\u5c31\u662f\u8bf4\uff0c\u53ea\u8981\u67d0\u4e2a\u4f4d\u88ab\u7f6e\u4f4d\uff0c\u6211\u4eec\u5c31\u80fd\u786e\u5b9a\u76f8\u5e94\u6761\u4ef6\u786e\u5b9e\u6210\u7acb\uff1b\u4f46\u5982\u679c\u67d0\u4e2a\u4f4d\u6ca1\u6709\u7f6e\u4f4d\uff0c\u8be5\u6761\u4ef6\u65e2\u53ef\u80fd\u4e3a\u771f\uff0c\u4e5f\u53ef\u80fd\u4e0d\u4e3a\u771f\u3002\u53ef\u89c1\u6027\u6620\u5c04\u4f4d\u53ea\u4f1a\u7531 VACUUM \u8bbe\u7f6e\uff0c\u4f46\u9875\u9762\u4e0a\u7684\u4efb\u4f55\u6570\u636e\u4fee\u6539\u64cd\u4f5c\u90fd\u4f1a\u628a\u5b83\u4eec\u6e05\u9664\u3002

\n

pg_visibility\u6a21\u5757\u53ef\u7528\u4e8e\u68c0\u67e5\u53ef\u89c1\u6027\u6620\u5c04\u4e2d\u5b58\u50a8\u7684\u4fe1\u606f\u3002

\n
", "manual_path": "/docs/15/storage-vm.html", "localization": {"status": "complete", "sources": [{"url": "/docs/15/storage-vm.html", "method": "same-major semantic node", "sha256": "b114ddadeabd626c9ae7037d2369f22be128146b68f1c2c43738394c85adb394", "language": "zh", "matched_nodes": ["#STORAGE-VM/div[0]", "#STORAGE-VM/p[3]", "#STORAGE-VM/p[4]", "#STORAGE-VM/p[5]", "#STORAGE-VM/p[6]"]}], "language": "zh", "original_text": {"/versions/15/description/0": "Each heap relation has a Visibility Map (VM) to keep track of which pages contain only tuples that are known to be visible to all active transactions; it also keeps track of which pages contain only frozen tuples. It's stored alongside the main relation data in a separate relation fork, named after the filenode number of the relation, plus a _vm suffix. For example, if the filenode of a relation is 12345, the VM is stored in a file called 12345_vm , in the same directory as the main relation file. Note that indexes do not have VMs.", "/versions/15/facts/0/label": "Definition scope", "/versions/15/facts/0/value": "Same-version core physical storage documentation", "/versions/15/related/1/label": "Storage Parameters"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "7b37678f295bac951745cafd6df6477f89124bcdfc19fcd70398e877ccfd4150"}, "comparison_data": {"layouts": []}, "comparison_hash": "27341929154bfb55531f03501322b65af719c5561f3c4ddc9528a14aa4df69b5", "manual_language": "zh"}, "16": {"facts": [{"label": "\u5b9a\u4e49\u8303\u56f4", "value": "\u540c\u7248\u672c\u6838\u5fc3\u7269\u7406\u5b58\u50a8\u6587\u6863"}], "tables": [], "related": [{"url": "/wiki/tableam/?v=16", "label": "Table AM"}, {"url": "/wiki/relopts/?v=16", "label": "\u5b58\u50a8\u53c2\u6570"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v16.15/postgresql-16.15.tar.bz2", "label": "16.15", "major": "16", "channel": "stable", "revision": "c1575341fa7bd40f5274ea465b34390f4dc64cdd0770af327005caaeb9f6b7ed"}, "sources": [{"url": "https://pg.center/docs/16/storage-vm.html", "path": "storage-vm.html", "label": "PostgreSQL 16 English manual", "sha256": "28e96b85e3906ff2f5e96cfd5a6ce7aa0b328e321b2de83c9625339fd475f619", "language": "en", "original_url": "/docs/16/storage-vm.html"}], "sections": [], "signature": "", "description": ["\u6bcf\u4e2a\u5806\u5173\u7cfb\u90fd\u6709\u4e00\u4e2a\u53ef\u89c1\u6027\u6620\u5c04\uff08VM\uff09\uff0c\u7528\u4e8e\u8ddf\u8e2a\u54ea\u4e9b\u9875\u9762\u53ea\u5305\u542b\u5df2\u77e5\u5bf9\u6240\u6709\u6d3b\u52a8\u4e8b\u52a1\u90fd\u53ef\u89c1\u7684\u5143\u7ec4\uff1b\u5b83\u8fd8\u4f1a\u8ddf\u8e2a\u54ea\u4e9b\u9875\u9762\u53ea\u5305\u542b\u5df2\u51bb\u7ed3\u7684\u5143\u7ec4\u3002\u5b83\u4e0e\u4e3b\u5173\u7cfb\u6570\u636e\u5e76\u5217\u5b58\u653e\u5728\u4e00\u4e2a\u72ec\u7acb\u7684\u5173\u7cfb\u5206\u652f\u4e2d\uff0c\u540d\u79f0\u7531\u5173\u7cfb\u7684\u6587\u4ef6\u8282\u70b9\u7f16\u53f7\u52a0\u4e0a _vm \u540e\u7f00\u6784\u6210\u3002\u4f8b\u5982\uff0c\u5982\u679c\u67d0\u5173\u7cfb\u7684\u6587\u4ef6\u8282\u70b9\u662f 12345\uff0c\u90a3\u4e48 VM \u4f1a\u5b58\u50a8\u5728\u540d\u4e3a 12345_vm \u7684\u6587\u4ef6\u4e2d\uff0c\u4e0e\u4e3b\u5173\u7cfb\u6587\u4ef6\u4f4d\u4e8e\u540c\u4e00\u76ee\u5f55\u3002\u8bf7\u6ce8\u610f\uff0c\u7d22\u5f15\u6ca1\u6709 VM\u3002"], "manual_html": "
\n
\n
\n
\n

\n
\n
\n

73.4.\u00a0\u53ef\u89c1\u6027\u6620\u5c04

\n
\n
\n

\n
\n
\n
\n

\u6bcf\u4e2a\u5806\u5173\u7cfb\u90fd\u6709\u4e00\u4e2a\u53ef\u89c1\u6027\u6620\u5c04\uff08VM\uff09\uff0c\u7528\u4e8e\u8ddf\u8e2a\u54ea\u4e9b\u9875\u9762\u53ea\u5305\u542b\u5df2\u77e5\u5bf9\u6240\u6709\u6d3b\u52a8\u4e8b\u52a1\u90fd\u53ef\u89c1\u7684\u5143\u7ec4\uff1b\u5b83\u8fd8\u4f1a\u8ddf\u8e2a\u54ea\u4e9b\u9875\u9762\u53ea\u5305\u542b\u5df2\u51bb\u7ed3\u7684\u5143\u7ec4\u3002\u5b83\u4e0e\u4e3b\u5173\u7cfb\u6570\u636e\u5e76\u5217\u5b58\u653e\u5728\u4e00\u4e2a\u72ec\u7acb\u7684\u5173\u7cfb\u5206\u652f\u4e2d\uff0c\u540d\u79f0\u7531\u5173\u7cfb\u7684\u6587\u4ef6\u8282\u70b9\u7f16\u53f7\u52a0\u4e0a _vm \u540e\u7f00\u6784\u6210\u3002\u4f8b\u5982\uff0c\u5982\u679c\u67d0\u5173\u7cfb\u7684\u6587\u4ef6\u8282\u70b9\u662f 12345\uff0c\u90a3\u4e48 VM \u4f1a\u5b58\u50a8\u5728\u540d\u4e3a 12345_vm \u7684\u6587\u4ef6\u4e2d\uff0c\u4e0e\u4e3b\u5173\u7cfb\u6587\u4ef6\u4f4d\u4e8e\u540c\u4e00\u76ee\u5f55\u3002\u8bf7\u6ce8\u610f\uff0c\u7d22\u5f15\u6ca1\u6709 VM\u3002

\n

\u53ef\u89c1\u6027\u6620\u5c04\u4e3a\u6bcf\u4e2a\u5806\u9875\u9762\u5b58\u50a8\u4e24\u4e2a\u4f4d\u3002\u7b2c\u4e00\u4f4d\u82e5\u88ab\u7f6e\u4f4d\uff0c\u8868\u793a\u8be5\u9875\u9762\u662f\u5168\u90e8\u53ef\u89c1\uff08all-visible\uff09\uff0c\u6362\u53e5\u8bdd\u8bf4\uff0c\u8be5\u9875\u9762\u4e0d\u5305\u542b\u4efb\u4f55\u9700\u8981\u88ab\u6e05\u7406\u7684\u5143\u7ec4\u3002\u8fd9\u4e9b\u4fe1\u606f\u8fd8\u53ef\u4ee5\u88ab\u4ec5\u7d22\u5f15\u626b\u63cf\u7528\u6765\u53ea\u4f9d\u636e\u7d22\u5f15\u5143\u7ec4\u56de\u7b54\u67e5\u8be2\u3002\u7b2c\u4e8c\u4f4d\u82e5\u88ab\u7f6e\u4f4d\uff0c\u5219\u8868\u793a\u9875\u9762\u4e0a\u7684\u6240\u6709\u5143\u7ec4\u90fd\u5df2\u7ecf\u88ab\u51bb\u7ed3\u3002\u8fd9\u610f\u5473\u7740\uff0c\u5373\u4f7f\u662f\u9632\u56de\u5377\u6e05\u7406\u4e5f\u4e0d\u5fc5\u91cd\u65b0\u8bbf\u95ee\u8be5\u9875\u9762\u3002

\n

\u8fd9\u4e2a\u6620\u5c04\u662f\u4fdd\u5b88\u7684\uff0c\u4e5f\u5c31\u662f\u8bf4\uff0c\u53ea\u8981\u67d0\u4e2a\u4f4d\u88ab\u7f6e\u4f4d\uff0c\u6211\u4eec\u5c31\u80fd\u786e\u5b9a\u76f8\u5e94\u6761\u4ef6\u786e\u5b9e\u6210\u7acb\uff1b\u4f46\u5982\u679c\u67d0\u4e2a\u4f4d\u6ca1\u6709\u7f6e\u4f4d\uff0c\u8be5\u6761\u4ef6\u65e2\u53ef\u80fd\u4e3a\u771f\uff0c\u4e5f\u53ef\u80fd\u4e0d\u4e3a\u771f\u3002\u53ef\u89c1\u6027\u6620\u5c04\u4f4d\u53ea\u4f1a\u7531 VACUUM \u8bbe\u7f6e\uff0c\u4f46\u9875\u9762\u4e0a\u7684\u4efb\u4f55\u6570\u636e\u4fee\u6539\u64cd\u4f5c\u90fd\u4f1a\u628a\u5b83\u4eec\u6e05\u9664\u3002

\n

pg_visibility\u6a21\u5757\u53ef\u7528\u4e8e\u68c0\u67e5\u53ef\u89c1\u6027\u6620\u5c04\u4e2d\u5b58\u50a8\u7684\u4fe1\u606f\u3002

\n
", "manual_path": "/docs/16/storage-vm.html", "localization": {"status": "complete", "sources": [{"url": "/docs/16/storage-vm.html", "method": "same-major semantic node", "sha256": "b7a0d656e7481e4824f86c18297c6e83742db91282878dd3a9d1a4f8eaf7b47a", "language": "zh", "matched_nodes": ["#STORAGE-VM/div[0]", "#STORAGE-VM/p[3]", "#STORAGE-VM/p[4]", "#STORAGE-VM/p[5]", "#STORAGE-VM/p[6]"]}], "language": "zh", "original_text": {"/versions/16/description/0": "Each heap relation has a Visibility Map (VM) to keep track of which pages contain only tuples that are known to be visible to all active transactions; it also keeps track of which pages contain only frozen tuples. It's stored alongside the main relation data in a separate relation fork, named after the filenode number of the relation, plus a _vm suffix. For example, if the filenode of a relation is 12345, the VM is stored in a file called 12345_vm , in the same directory as the main relation file. Note that indexes do not have VMs.", "/versions/16/facts/0/label": "Definition scope", "/versions/16/facts/0/value": "Same-version core physical storage documentation", "/versions/16/related/1/label": "Storage Parameters"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "4aca1d24be2f40605c82c9127139c0bbc1610725f9463bc24d8bbeb55a7ec1ae"}, "comparison_data": {"layouts": []}, "comparison_hash": "27341929154bfb55531f03501322b65af719c5561f3c4ddc9528a14aa4df69b5", "manual_language": "zh"}, "17": {"facts": [{"label": "\u5b9a\u4e49\u8303\u56f4", "value": "\u540c\u7248\u672c\u6838\u5fc3\u7269\u7406\u5b58\u50a8\u6587\u6863"}], "tables": [], "related": [{"url": "/wiki/tableam/?v=17", "label": "Table AM"}, {"url": "/wiki/relopts/?v=17", "label": "\u5b58\u50a8\u53c2\u6570"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v17.11/postgresql-17.11.tar.bz2", "label": "17.11", "major": "17", "channel": "stable", "revision": "dd27f2b3c59e73ed14aa3324901242bf69a032a6347805f274e6260322d42979"}, "sources": [{"url": "https://pg.center/docs/17/storage-vm.html", "path": "storage-vm.html", "label": "PostgreSQL 17 English manual", "sha256": "379eaf2c677be957ae9b4d92b7d859f6bdd433fb5c7829ff36227f35ff36f2cb", "language": "en", "original_url": "/docs/17/storage-vm.html"}], "sections": [], "signature": "", "description": ["\u6bcf\u4e2a\u5806\u5173\u7cfb\u90fd\u6709\u4e00\u4e2a\u53ef\u89c1\u6027\u6620\u5c04\uff08VM\uff09\uff0c\u7528\u4e8e\u8ddf\u8e2a\u54ea\u4e9b\u9875\u9762\u53ea\u5305\u542b\u5df2\u77e5\u5bf9\u6240\u6709\u6d3b\u52a8\u4e8b\u52a1\u90fd\u53ef\u89c1\u7684\u5143\u7ec4\uff1b\u5b83\u8fd8\u4f1a\u8ddf\u8e2a\u54ea\u4e9b\u9875\u9762\u53ea\u5305\u542b\u5df2\u51bb\u7ed3\u7684\u5143\u7ec4\u3002\u5b83\u4e0e\u4e3b\u5173\u7cfb\u6570\u636e\u5e76\u5217\u5b58\u653e\u5728\u4e00\u4e2a\u72ec\u7acb\u7684\u5173\u7cfb\u5206\u652f\u4e2d\uff0c\u540d\u79f0\u7531\u5173\u7cfb\u7684\u6587\u4ef6\u8282\u70b9\u7f16\u53f7\u52a0\u4e0a _vm \u540e\u7f00\u6784\u6210\u3002\u4f8b\u5982\uff0c\u5982\u679c\u67d0\u5173\u7cfb\u7684\u6587\u4ef6\u8282\u70b9\u662f 12345\uff0c\u90a3\u4e48 VM \u4f1a\u5b58\u50a8\u5728\u540d\u4e3a 12345_vm \u7684\u6587\u4ef6\u4e2d\uff0c\u4e0e\u4e3b\u5173\u7cfb\u6587\u4ef6\u4f4d\u4e8e\u540c\u4e00\u76ee\u5f55\u3002\u8bf7\u6ce8\u610f\uff0c\u7d22\u5f15\u6ca1\u6709 VM\u3002"], "manual_html": "
\n
\n
\n
\n

\n
\n
\n

65.4.\u00a0\u53ef\u89c1\u6027\u6620\u5c04

\n
\n
\n

\n
\n
\n
\n

\u6bcf\u4e2a\u5806\u5173\u7cfb\u90fd\u6709\u4e00\u4e2a\u53ef\u89c1\u6027\u6620\u5c04\uff08VM\uff09\uff0c\u7528\u4e8e\u8ddf\u8e2a\u54ea\u4e9b\u9875\u9762\u53ea\u5305\u542b\u5df2\u77e5\u5bf9\u6240\u6709\u6d3b\u52a8\u4e8b\u52a1\u90fd\u53ef\u89c1\u7684\u5143\u7ec4\uff1b\u5b83\u8fd8\u4f1a\u8ddf\u8e2a\u54ea\u4e9b\u9875\u9762\u53ea\u5305\u542b\u5df2\u51bb\u7ed3\u7684\u5143\u7ec4\u3002\u5b83\u4e0e\u4e3b\u5173\u7cfb\u6570\u636e\u5e76\u5217\u5b58\u653e\u5728\u4e00\u4e2a\u72ec\u7acb\u7684\u5173\u7cfb\u5206\u652f\u4e2d\uff0c\u540d\u79f0\u7531\u5173\u7cfb\u7684\u6587\u4ef6\u8282\u70b9\u7f16\u53f7\u52a0\u4e0a _vm \u540e\u7f00\u6784\u6210\u3002\u4f8b\u5982\uff0c\u5982\u679c\u67d0\u5173\u7cfb\u7684\u6587\u4ef6\u8282\u70b9\u662f 12345\uff0c\u90a3\u4e48 VM \u4f1a\u5b58\u50a8\u5728\u540d\u4e3a 12345_vm \u7684\u6587\u4ef6\u4e2d\uff0c\u4e0e\u4e3b\u5173\u7cfb\u6587\u4ef6\u4f4d\u4e8e\u540c\u4e00\u76ee\u5f55\u3002\u8bf7\u6ce8\u610f\uff0c\u7d22\u5f15\u6ca1\u6709 VM\u3002

\n

\u53ef\u89c1\u6027\u6620\u5c04\u4e3a\u6bcf\u4e2a\u5806\u9875\u9762\u5b58\u50a8\u4e24\u4e2a\u4f4d\u3002\u7b2c\u4e00\u4f4d\u82e5\u88ab\u7f6e\u4f4d\uff0c\u8868\u793a\u8be5\u9875\u9762\u662f\u5168\u90e8\u53ef\u89c1\uff08all-visible\uff09\uff0c\u6362\u53e5\u8bdd\u8bf4\uff0c\u8be5\u9875\u9762\u4e0d\u5305\u542b\u4efb\u4f55\u9700\u8981\u88ab\u6e05\u7406\u7684\u5143\u7ec4\u3002\u8fd9\u4e9b\u4fe1\u606f\u8fd8\u53ef\u4ee5\u88ab\u4ec5\u7d22\u5f15\u626b\u63cf\u7528\u6765\u53ea\u4f9d\u636e\u7d22\u5f15\u5143\u7ec4\u56de\u7b54\u67e5\u8be2\u3002\u7b2c\u4e8c\u4f4d\u82e5\u88ab\u7f6e\u4f4d\uff0c\u5219\u8868\u793a\u9875\u9762\u4e0a\u7684\u6240\u6709\u5143\u7ec4\u90fd\u5df2\u7ecf\u88ab\u51bb\u7ed3\u3002\u8fd9\u610f\u5473\u7740\uff0c\u5373\u4f7f\u662f\u9632\u56de\u5377\u6e05\u7406\u4e5f\u4e0d\u5fc5\u91cd\u65b0\u8bbf\u95ee\u8be5\u9875\u9762\u3002

\n

\u8fd9\u4e2a\u6620\u5c04\u662f\u4fdd\u5b88\u7684\uff0c\u4e5f\u5c31\u662f\u8bf4\uff0c\u53ea\u8981\u67d0\u4e2a\u4f4d\u88ab\u7f6e\u4f4d\uff0c\u6211\u4eec\u5c31\u80fd\u786e\u5b9a\u76f8\u5e94\u6761\u4ef6\u786e\u5b9e\u6210\u7acb\uff1b\u4f46\u5982\u679c\u67d0\u4e2a\u4f4d\u6ca1\u6709\u7f6e\u4f4d\uff0c\u8be5\u6761\u4ef6\u65e2\u53ef\u80fd\u4e3a\u771f\uff0c\u4e5f\u53ef\u80fd\u4e0d\u4e3a\u771f\u3002\u53ef\u89c1\u6027\u6620\u5c04\u4f4d\u53ea\u4f1a\u7531 VACUUM \u8bbe\u7f6e\uff0c\u4f46\u9875\u9762\u4e0a\u7684\u4efb\u4f55\u6570\u636e\u4fee\u6539\u64cd\u4f5c\u90fd\u4f1a\u628a\u5b83\u4eec\u6e05\u9664\u3002

\n

pg_visibility\u6a21\u5757\u53ef\u7528\u4e8e\u68c0\u67e5\u53ef\u89c1\u6027\u6620\u5c04\u4e2d\u5b58\u50a8\u7684\u4fe1\u606f\u3002

\n
", "manual_path": "/docs/17/storage-vm.html", "localization": {"status": "complete", "sources": [{"url": "/docs/17/storage-vm.html", "method": "same-major semantic node", "sha256": "60942733781de80d925e7b1854554350d2c06250b1bc6c27ab60e73309049558", "language": "zh", "matched_nodes": ["#STORAGE-VM/div[0]", "#STORAGE-VM/p[3]", "#STORAGE-VM/p[4]", "#STORAGE-VM/p[5]", "#STORAGE-VM/p[6]"]}], "language": "zh", "original_text": {"/versions/17/description/0": "Each heap relation has a Visibility Map (VM) to keep track of which pages contain only tuples that are known to be visible to all active transactions; it also keeps track of which pages contain only frozen tuples. It's stored alongside the main relation data in a separate relation fork, named after the filenode number of the relation, plus a _vm suffix. For example, if the filenode of a relation is 12345, the VM is stored in a file called 12345_vm , in the same directory as the main relation file. Note that indexes do not have VMs.", "/versions/17/facts/0/label": "Definition scope", "/versions/17/facts/0/value": "Same-version core physical storage documentation", "/versions/17/related/1/label": "Storage Parameters"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "5b14ff355d2fc45a8bbdbcee73be44118b8684132ab5c737488906c5a3003b35"}, "comparison_data": {"layouts": []}, "comparison_hash": "27341929154bfb55531f03501322b65af719c5561f3c4ddc9528a14aa4df69b5", "manual_language": "zh"}, "18": {"facts": [{"label": "\u5b9a\u4e49\u8303\u56f4", "value": "\u540c\u7248\u672c\u6838\u5fc3\u7269\u7406\u5b58\u50a8\u6587\u6863"}], "tables": [], "related": [{"url": "/wiki/tableam/?v=18", "label": "Table AM"}, {"url": "/wiki/relopts/?v=18", "label": "\u5b58\u50a8\u53c2\u6570"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "label": "18.6", "major": "18", "channel": "stable", "revision": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "sources": [{"url": "https://pg.center/docs/18/storage-vm.html", "path": "storage-vm.html", "label": "PostgreSQL 18 English manual", "sha256": "26b3512091ad6215922297afdfbf457448a1d6dee9b2df2c69ed5b25cd3df5e0", "language": "en", "original_url": "/docs/18/storage-vm.html"}], "sections": [], "signature": "", "description": ["\u6bcf\u4e2a\u5806\u5173\u7cfb\u90fd\u6709\u4e00\u4e2a\u53ef\u89c1\u6027\u6620\u5c04\uff08VM\uff09\uff0c\u7528\u4e8e\u8ddf\u8e2a\u54ea\u4e9b\u9875\u9762\u53ea\u5305\u542b\u5df2\u77e5\u5bf9\u6240\u6709\u6d3b\u52a8\u4e8b\u52a1\u90fd\u53ef\u89c1\u7684\u5143\u7ec4\uff1b\u5b83\u8fd8\u4f1a\u8ddf\u8e2a\u54ea\u4e9b\u9875\u9762\u53ea\u5305\u542b\u5df2\u51bb\u7ed3\u7684\u5143\u7ec4\u3002\u5b83\u4e0e\u4e3b\u5173\u7cfb\u6570\u636e\u5e76\u5217\u5b58\u653e\u5728\u4e00\u4e2a\u72ec\u7acb\u7684\u5173\u7cfb\u5206\u652f\u4e2d\uff0c\u540d\u79f0\u7531\u5173\u7cfb\u7684\u6587\u4ef6\u8282\u70b9\u7f16\u53f7\u52a0\u4e0a _vm \u540e\u7f00\u6784\u6210\u3002\u4f8b\u5982\uff0c\u5982\u679c\u67d0\u5173\u7cfb\u7684\u6587\u4ef6\u8282\u70b9\u662f 12345\uff0c\u90a3\u4e48 VM \u4f1a\u5b58\u50a8\u5728\u540d\u4e3a 12345_vm \u7684\u6587\u4ef6\u4e2d\uff0c\u4e0e\u4e3b\u5173\u7cfb\u6587\u4ef6\u4f4d\u4e8e\u540c\u4e00\u76ee\u5f55\u3002\u8bf7\u6ce8\u610f\uff0c\u7d22\u5f15\u6ca1\u6709 VM\u3002"], "manual_html": "
\n
\n
\n
\n

\n
\n
\n

66.4.\u00a0\u53ef\u89c1\u6027\u6620\u5c04

\n
\n
\n

\n
\n
\n
\n

\u6bcf\u4e2a\u5806\u5173\u7cfb\u90fd\u6709\u4e00\u4e2a\u53ef\u89c1\u6027\u6620\u5c04\uff08VM\uff09\uff0c\u7528\u4e8e\u8ddf\u8e2a\u54ea\u4e9b\u9875\u9762\u53ea\u5305\u542b\u5df2\u77e5\u5bf9\u6240\u6709\u6d3b\u52a8\u4e8b\u52a1\u90fd\u53ef\u89c1\u7684\u5143\u7ec4\uff1b\u5b83\u8fd8\u4f1a\u8ddf\u8e2a\u54ea\u4e9b\u9875\u9762\u53ea\u5305\u542b\u5df2\u51bb\u7ed3\u7684\u5143\u7ec4\u3002\u5b83\u4e0e\u4e3b\u5173\u7cfb\u6570\u636e\u5e76\u5217\u5b58\u653e\u5728\u4e00\u4e2a\u72ec\u7acb\u7684\u5173\u7cfb\u5206\u652f\u4e2d\uff0c\u540d\u79f0\u7531\u5173\u7cfb\u7684\u6587\u4ef6\u8282\u70b9\u7f16\u53f7\u52a0\u4e0a _vm \u540e\u7f00\u6784\u6210\u3002\u4f8b\u5982\uff0c\u5982\u679c\u67d0\u5173\u7cfb\u7684\u6587\u4ef6\u8282\u70b9\u662f 12345\uff0c\u90a3\u4e48 VM \u4f1a\u5b58\u50a8\u5728\u540d\u4e3a 12345_vm \u7684\u6587\u4ef6\u4e2d\uff0c\u4e0e\u4e3b\u5173\u7cfb\u6587\u4ef6\u4f4d\u4e8e\u540c\u4e00\u76ee\u5f55\u3002\u8bf7\u6ce8\u610f\uff0c\u7d22\u5f15\u6ca1\u6709 VM\u3002

\n

\u53ef\u89c1\u6027\u6620\u5c04\u4e3a\u6bcf\u4e2a\u5806\u9875\u9762\u5b58\u50a8\u4e24\u4e2a\u4f4d\u3002\u7b2c\u4e00\u4f4d\u82e5\u88ab\u7f6e\u4f4d\uff0c\u8868\u793a\u8be5\u9875\u9762\u662f\u5168\u90e8\u53ef\u89c1\uff08all-visible\uff09\uff0c\u6362\u53e5\u8bdd\u8bf4\uff0c\u8be5\u9875\u9762\u4e0d\u5305\u542b\u4efb\u4f55\u9700\u8981\u88ab\u6e05\u7406\u7684\u5143\u7ec4\u3002\u8fd9\u4e9b\u4fe1\u606f\u8fd8\u53ef\u4ee5\u88ab\u4ec5\u7d22\u5f15\u626b\u63cf\u7528\u6765\u53ea\u4f9d\u636e\u7d22\u5f15\u5143\u7ec4\u56de\u7b54\u67e5\u8be2\u3002\u7b2c\u4e8c\u4f4d\u82e5\u88ab\u7f6e\u4f4d\uff0c\u5219\u8868\u793a\u9875\u9762\u4e0a\u7684\u6240\u6709\u5143\u7ec4\u90fd\u5df2\u7ecf\u88ab\u51bb\u7ed3\u3002\u8fd9\u610f\u5473\u7740\uff0c\u5373\u4f7f\u662f\u9632\u56de\u5377\u6e05\u7406\u4e5f\u4e0d\u5fc5\u91cd\u65b0\u8bbf\u95ee\u8be5\u9875\u9762\u3002

\n

\u8fd9\u4e2a\u6620\u5c04\u662f\u4fdd\u5b88\u7684\uff0c\u4e5f\u5c31\u662f\u8bf4\uff0c\u53ea\u8981\u67d0\u4e2a\u4f4d\u88ab\u7f6e\u4f4d\uff0c\u6211\u4eec\u5c31\u80fd\u786e\u5b9a\u76f8\u5e94\u6761\u4ef6\u786e\u5b9e\u6210\u7acb\uff1b\u4f46\u5982\u679c\u67d0\u4e2a\u4f4d\u6ca1\u6709\u7f6e\u4f4d\uff0c\u8be5\u6761\u4ef6\u65e2\u53ef\u80fd\u4e3a\u771f\uff0c\u4e5f\u53ef\u80fd\u4e0d\u4e3a\u771f\u3002\u53ef\u89c1\u6027\u6620\u5c04\u4f4d\u53ea\u4f1a\u7531 VACUUM \u8bbe\u7f6e\uff0c\u4f46\u9875\u9762\u4e0a\u7684\u4efb\u4f55\u6570\u636e\u4fee\u6539\u64cd\u4f5c\u90fd\u4f1a\u628a\u5b83\u4eec\u6e05\u9664\u3002

\n

pg_visibility\u6a21\u5757\u53ef\u7528\u4e8e\u68c0\u67e5\u53ef\u89c1\u6027\u6620\u5c04\u4e2d\u5b58\u50a8\u7684\u4fe1\u606f\u3002

\n
", "manual_path": "/docs/18/storage-vm.html", "localization": {"status": "complete", "sources": [{"url": "/docs/18/storage-vm.html", "method": "same-major semantic node", "sha256": "add821d03c017af92f191665db38e3a6920b430c73c75f2539d825bbce82a373", "language": "zh", "matched_nodes": ["#STORAGE-VM/div[0]", "#STORAGE-VM/p[3]", "#STORAGE-VM/p[4]", "#STORAGE-VM/p[5]", "#STORAGE-VM/p[6]"]}], "language": "zh", "original_text": {"/versions/18/description/0": "Each heap relation has a Visibility Map (VM) to keep track of which pages contain only tuples that are known to be visible to all active transactions; it also keeps track of which pages contain only frozen tuples. It's stored alongside the main relation data in a separate relation fork, named after the filenode number of the relation, plus a _vm suffix. For example, if the filenode of a relation is 12345, the VM is stored in a file called 12345_vm , in the same directory as the main relation file. Note that indexes do not have VMs.", "/versions/18/facts/0/label": "Definition scope", "/versions/18/facts/0/value": "Same-version core physical storage documentation", "/versions/18/related/1/label": "Storage Parameters"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "162e406b7b64fe31e8ce46c31ce1e13e9ca69c4e69f1309fca89ea8fea8a2613"}, "comparison_data": {"layouts": []}, "comparison_hash": "27341929154bfb55531f03501322b65af719c5561f3c4ddc9528a14aa4df69b5", "manual_language": "zh"}, "19": {"facts": [{"label": "\u5b9a\u4e49\u8303\u56f4", "value": "\u540c\u7248\u672c\u6838\u5fc3\u7269\u7406\u5b58\u50a8\u6587\u6863"}], "tables": [], "related": [{"url": "/wiki/tableam/?v=19", "label": "Table AM"}, {"url": "/wiki/relopts/?v=19", "label": "\u5b58\u50a8\u53c2\u6570"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v19beta4/postgresql-19beta4.tar.bz2", "label": "19beta4", "major": "19", "channel": "preview", "revision": "83157ee9c599d03b2f7a3d73ef3a56ec24e0e79cc2b3501a64d1364f56398c86"}, "sources": [{"url": "https://pg.center/docs/19/storage-vm.html", "path": "storage-vm.html", "label": "PostgreSQL 19 English manual", "sha256": "b294d3053598cf2088deaef6c1284d40337744e2a5ec9d375ed3566496bd7695", "language": "en", "original_url": "/docs/19/storage-vm.html"}], "sections": [], "signature": "", "description": ["\u6bcf\u4e2a\u5806\u5173\u7cfb\u90fd\u6709\u4e00\u4e2a\u53ef\u89c1\u6027\u6620\u5c04\uff08VM\uff09\uff0c\u7528\u4e8e\u8ddf\u8e2a\u54ea\u4e9b\u9875\u9762\u53ea\u5305\u542b\u5df2\u77e5\u5bf9\u6240\u6709\u6d3b\u52a8\u4e8b\u52a1\u90fd\u53ef\u89c1\u7684\u5143\u7ec4\uff1b\u5b83\u8fd8\u4f1a\u8ddf\u8e2a\u54ea\u4e9b\u9875\u9762\u53ea\u5305\u542b\u5df2\u51bb\u7ed3\u7684\u5143\u7ec4\u3002\u5b83\u4e0e\u4e3b\u5173\u7cfb\u6570\u636e\u5e76\u5217\u5b58\u653e\u5728\u4e00\u4e2a\u72ec\u7acb\u7684\u5173\u7cfb\u5206\u652f\u4e2d\uff0c\u540d\u79f0\u7531\u5173\u7cfb\u7684\u6587\u4ef6\u8282\u70b9\u7f16\u53f7\u52a0\u4e0a _vm \u540e\u7f00\u6784\u6210\u3002\u4f8b\u5982\uff0c\u5982\u679c\u67d0\u5173\u7cfb\u7684\u6587\u4ef6\u8282\u70b9\u662f 12345\uff0c\u90a3\u4e48 VM \u4f1a\u5b58\u50a8\u5728\u540d\u4e3a 12345_vm \u7684\u6587\u4ef6\u4e2d\uff0c\u4e0e\u4e3b\u5173\u7cfb\u6587\u4ef6\u4f4d\u4e8e\u540c\u4e00\u76ee\u5f55\u3002\u8bf7\u6ce8\u610f\uff0c\u7d22\u5f15\u6ca1\u6709 VM\u3002"], "manual_html": "
\n
\n
\n
\n

\n
\n
\n

66.4.\u00a0\u53ef\u89c1\u6027\u6620\u5c04

\n
\n
\n

\n
\n
\n
\n

\u6bcf\u4e2a\u5806\u5173\u7cfb\u90fd\u6709\u4e00\u4e2a\u53ef\u89c1\u6027\u6620\u5c04\uff08VM\uff09\uff0c\u7528\u4e8e\u8ddf\u8e2a\u54ea\u4e9b\u9875\u9762\u53ea\u5305\u542b\u5df2\u77e5\u5bf9\u6240\u6709\u6d3b\u52a8\u4e8b\u52a1\u90fd\u53ef\u89c1\u7684\u5143\u7ec4\uff1b\u5b83\u8fd8\u4f1a\u8ddf\u8e2a\u54ea\u4e9b\u9875\u9762\u53ea\u5305\u542b\u5df2\u51bb\u7ed3\u7684\u5143\u7ec4\u3002\u5b83\u4e0e\u4e3b\u5173\u7cfb\u6570\u636e\u5e76\u5217\u5b58\u653e\u5728\u4e00\u4e2a\u72ec\u7acb\u7684\u5173\u7cfb\u5206\u652f\u4e2d\uff0c\u540d\u79f0\u7531\u5173\u7cfb\u7684\u6587\u4ef6\u8282\u70b9\u7f16\u53f7\u52a0\u4e0a _vm \u540e\u7f00\u6784\u6210\u3002\u4f8b\u5982\uff0c\u5982\u679c\u67d0\u5173\u7cfb\u7684\u6587\u4ef6\u8282\u70b9\u662f 12345\uff0c\u90a3\u4e48 VM \u4f1a\u5b58\u50a8\u5728\u540d\u4e3a 12345_vm \u7684\u6587\u4ef6\u4e2d\uff0c\u4e0e\u4e3b\u5173\u7cfb\u6587\u4ef6\u4f4d\u4e8e\u540c\u4e00\u76ee\u5f55\u3002\u8bf7\u6ce8\u610f\uff0c\u7d22\u5f15\u6ca1\u6709 VM\u3002

\n

\u53ef\u89c1\u6027\u6620\u5c04\u4e3a\u6bcf\u4e2a\u5806\u9875\u9762\u5b58\u50a8\u4e24\u4e2a\u4f4d\u3002\u7b2c\u4e00\u4f4d\u82e5\u88ab\u7f6e\u4f4d\uff0c\u8868\u793a\u8be5\u9875\u9762\u662f\u5168\u90e8\u53ef\u89c1\uff08all-visible\uff09\uff0c\u6362\u53e5\u8bdd\u8bf4\uff0c\u8be5\u9875\u9762\u4e0d\u5305\u542b\u4efb\u4f55\u9700\u8981\u88ab\u6e05\u7406\u7684\u5143\u7ec4\u3002\u8fd9\u4e9b\u4fe1\u606f\u8fd8\u53ef\u4ee5\u88ab\u4ec5\u7d22\u5f15\u626b\u63cf\u7528\u6765\u53ea\u4f9d\u636e\u7d22\u5f15\u5143\u7ec4\u56de\u7b54\u67e5\u8be2\u3002\u7b2c\u4e8c\u4f4d\u82e5\u88ab\u7f6e\u4f4d\uff0c\u5219\u8868\u793a\u9875\u9762\u4e0a\u7684\u6240\u6709\u5143\u7ec4\u90fd\u5df2\u7ecf\u88ab\u51bb\u7ed3\u3002\u8fd9\u610f\u5473\u7740\uff0c\u5373\u4f7f\u662f\u9632\u56de\u5377\u6e05\u7406\u4e5f\u4e0d\u5fc5\u91cd\u65b0\u8bbf\u95ee\u8be5\u9875\u9762\u3002

\n

\u8fd9\u4e2a\u6620\u5c04\u662f\u4fdd\u5b88\u7684\uff0c\u4e5f\u5c31\u662f\u8bf4\uff0c\u53ea\u8981\u67d0\u4e2a\u4f4d\u88ab\u7f6e\u4f4d\uff0c\u6211\u4eec\u5c31\u80fd\u786e\u5b9a\u76f8\u5e94\u6761\u4ef6\u786e\u5b9e\u6210\u7acb\uff1b\u4f46\u5982\u679c\u67d0\u4e2a\u4f4d\u6ca1\u6709\u7f6e\u4f4d\uff0c\u8be5\u6761\u4ef6\u65e2\u53ef\u80fd\u4e3a\u771f\uff0c\u4e5f\u53ef\u80fd\u4e0d\u4e3a\u771f\u3002\u53ef\u89c1\u6027\u6620\u5c04\u4f4d\u53ea\u4f1a\u7531 VACUUM \u8bbe\u7f6e\uff0c\u4f46\u9875\u9762\u4e0a\u7684\u4efb\u4f55\u6570\u636e\u4fee\u6539\u64cd\u4f5c\u90fd\u4f1a\u628a\u5b83\u4eec\u6e05\u9664\u3002

\n

pg_visibility\u6a21\u5757\u53ef\u7528\u4e8e\u68c0\u67e5\u53ef\u89c1\u6027\u6620\u5c04\u4e2d\u5b58\u50a8\u7684\u4fe1\u606f\u3002

\n
", "manual_path": "/docs/19/storage-vm.html", "localization": {"status": "complete", "sources": [{"url": "/docs/19/storage-vm.html", "method": "same-major semantic node", "sha256": "f86516be67de115e8d7d5b8e2e2eb623e3e66028c248411b9f4ed59c9356610c", "language": "zh", "matched_nodes": ["#STORAGE-VM/div[0]", "#STORAGE-VM/p[3]", "#STORAGE-VM/p[4]", "#STORAGE-VM/p[5]", "#STORAGE-VM/p[6]"]}], "language": "zh", "original_text": {"/versions/19/description/0": "Each heap relation has a Visibility Map (VM) to keep track of which pages contain only tuples that are known to be visible to all active transactions; it also keeps track of which pages contain only frozen tuples. It's stored alongside the main relation data in a separate relation fork, named after the filenode number of the relation, plus a _vm suffix. For example, if the filenode of a relation is 12345, the VM is stored in a file called 12345_vm , in the same directory as the main relation file. Note that indexes do not have VMs.", "/versions/19/facts/0/label": "Definition scope", "/versions/19/facts/0/value": "Same-version core physical storage documentation", "/versions/19/related/1/label": "Storage Parameters"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "e5b8a2d4453e68649d2723c7676f223db1f23f4f303492a5d3bc49fc772cb1bc"}, "comparison_data": {"layouts": []}, "comparison_hash": "27341929154bfb55531f03501322b65af719c5561f3c4ddc9528a14aa4df69b5", "manual_language": "zh"}, "20": {"facts": [{"label": "\u5b9a\u4e49\u8303\u56f4", "value": "\u540c\u7248\u672c\u6838\u5fc3\u7269\u7406\u5b58\u50a8\u6587\u6863"}], "tables": [], "related": [{"url": "/wiki/tableam/?v=20", "label": "Table AM"}, {"url": "/wiki/relopts/?v=20", "label": "\u5b58\u50a8\u53c2\u6570"}], "release": {"ref": "https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.bz2", "label": "20devel", "major": "20", "channel": "devel", "revision": "4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41"}, "sources": [{"url": "https://pg.center/docs/devel/storage-vm.html", "path": "storage-vm.html", "label": "PostgreSQL 20 English manual", "sha256": "e4cfe140b76d0a80b28ff9e5d3a3d48145297ba574e70f049afc8cd2b72abb1c", "language": "en", "original_url": "/docs/devel/storage-vm.html"}], "sections": [], "signature": "", "description": ["\u6bcf\u4e2a\u5806\u5173\u7cfb\u90fd\u6709\u4e00\u4e2a\u53ef\u89c1\u6027\u6620\u5c04\uff08VM\uff09\uff0c\u7528\u4e8e\u8ddf\u8e2a\u54ea\u4e9b\u9875\u9762\u53ea\u5305\u542b\u5df2\u77e5\u5bf9\u6240\u6709\u6d3b\u52a8\u4e8b\u52a1\u90fd\u53ef\u89c1\u7684\u5143\u7ec4\uff1b\u5b83\u8fd8\u4f1a\u8ddf\u8e2a\u54ea\u4e9b\u9875\u9762\u53ea\u5305\u542b\u5df2\u51bb\u7ed3\u7684\u5143\u7ec4\u3002\u5b83\u4e0e\u4e3b\u5173\u7cfb\u6570\u636e\u5e76\u5217\u5b58\u653e\u5728\u4e00\u4e2a\u72ec\u7acb\u7684\u5173\u7cfb\u5206\u652f\u4e2d\uff0c\u540d\u79f0\u7531\u5173\u7cfb\u7684\u6587\u4ef6\u8282\u70b9\u7f16\u53f7\u52a0\u4e0a _vm \u540e\u7f00\u6784\u6210\u3002\u4f8b\u5982\uff0c\u5982\u679c\u67d0\u5173\u7cfb\u7684\u6587\u4ef6\u8282\u70b9\u662f 12345\uff0c\u90a3\u4e48 VM \u4f1a\u5b58\u50a8\u5728\u540d\u4e3a 12345_vm \u7684\u6587\u4ef6\u4e2d\uff0c\u4e0e\u4e3b\u5173\u7cfb\u6587\u4ef6\u4f4d\u4e8e\u540c\u4e00\u76ee\u5f55\u3002\u8bf7\u6ce8\u610f\uff0c\u7d22\u5f15\u6ca1\u6709 VM\u3002"], "manual_html": "
\n
\n
\n
\n

\n
\n
\n

66.4.\u00a0\u53ef\u89c1\u6027\u6620\u5c04

\n
\n
\n

\n
\n
\n
\n

\u6bcf\u4e2a\u5806\u5173\u7cfb\u90fd\u6709\u4e00\u4e2a\u53ef\u89c1\u6027\u6620\u5c04\uff08VM\uff09\uff0c\u7528\u4e8e\u8ddf\u8e2a\u54ea\u4e9b\u9875\u9762\u53ea\u5305\u542b\u5df2\u77e5\u5bf9\u6240\u6709\u6d3b\u52a8\u4e8b\u52a1\u90fd\u53ef\u89c1\u7684\u5143\u7ec4\uff1b\u5b83\u8fd8\u4f1a\u8ddf\u8e2a\u54ea\u4e9b\u9875\u9762\u53ea\u5305\u542b\u5df2\u51bb\u7ed3\u7684\u5143\u7ec4\u3002\u5b83\u4e0e\u4e3b\u5173\u7cfb\u6570\u636e\u5e76\u5217\u5b58\u653e\u5728\u4e00\u4e2a\u72ec\u7acb\u7684\u5173\u7cfb\u5206\u652f\u4e2d\uff0c\u540d\u79f0\u7531\u5173\u7cfb\u7684\u6587\u4ef6\u8282\u70b9\u7f16\u53f7\u52a0\u4e0a _vm \u540e\u7f00\u6784\u6210\u3002\u4f8b\u5982\uff0c\u5982\u679c\u67d0\u5173\u7cfb\u7684\u6587\u4ef6\u8282\u70b9\u662f 12345\uff0c\u90a3\u4e48 VM \u4f1a\u5b58\u50a8\u5728\u540d\u4e3a 12345_vm \u7684\u6587\u4ef6\u4e2d\uff0c\u4e0e\u4e3b\u5173\u7cfb\u6587\u4ef6\u4f4d\u4e8e\u540c\u4e00\u76ee\u5f55\u3002\u8bf7\u6ce8\u610f\uff0c\u7d22\u5f15\u6ca1\u6709 VM\u3002

\n

\u53ef\u89c1\u6027\u6620\u5c04\u4e3a\u6bcf\u4e2a\u5806\u9875\u9762\u5b58\u50a8\u4e24\u4e2a\u4f4d\u3002\u7b2c\u4e00\u4f4d\u82e5\u88ab\u7f6e\u4f4d\uff0c\u8868\u793a\u8be5\u9875\u9762\u662f\u5168\u90e8\u53ef\u89c1\uff08all-visible\uff09\uff0c\u6362\u53e5\u8bdd\u8bf4\uff0c\u8be5\u9875\u9762\u4e0d\u5305\u542b\u4efb\u4f55\u9700\u8981\u88ab\u6e05\u7406\u7684\u5143\u7ec4\u3002\u8fd9\u4e9b\u4fe1\u606f\u8fd8\u53ef\u4ee5\u88ab\u4ec5\u7d22\u5f15\u626b\u63cf\u7528\u6765\u53ea\u4f9d\u636e\u7d22\u5f15\u5143\u7ec4\u56de\u7b54\u67e5\u8be2\u3002\u7b2c\u4e8c\u4f4d\u82e5\u88ab\u7f6e\u4f4d\uff0c\u5219\u8868\u793a\u9875\u9762\u4e0a\u7684\u6240\u6709\u5143\u7ec4\u90fd\u5df2\u7ecf\u88ab\u51bb\u7ed3\u3002\u8fd9\u610f\u5473\u7740\uff0c\u5373\u4f7f\u662f\u9632\u56de\u5377\u6e05\u7406\u4e5f\u4e0d\u5fc5\u91cd\u65b0\u8bbf\u95ee\u8be5\u9875\u9762\u3002

\n

\u8fd9\u4e2a\u6620\u5c04\u662f\u4fdd\u5b88\u7684\uff0c\u4e5f\u5c31\u662f\u8bf4\uff0c\u53ea\u8981\u67d0\u4e2a\u4f4d\u88ab\u7f6e\u4f4d\uff0c\u6211\u4eec\u5c31\u80fd\u786e\u5b9a\u76f8\u5e94\u6761\u4ef6\u786e\u5b9e\u6210\u7acb\uff1b\u4f46\u5982\u679c\u67d0\u4e2a\u4f4d\u6ca1\u6709\u7f6e\u4f4d\uff0c\u8be5\u6761\u4ef6\u65e2\u53ef\u80fd\u4e3a\u771f\uff0c\u4e5f\u53ef\u80fd\u4e0d\u4e3a\u771f\u3002\u53ef\u89c1\u6027\u6620\u5c04\u4f4d\u53ea\u4f1a\u7531 VACUUM \u8bbe\u7f6e\uff0c\u4f46\u9875\u9762\u4e0a\u7684\u4efb\u4f55\u6570\u636e\u4fee\u6539\u64cd\u4f5c\u90fd\u4f1a\u628a\u5b83\u4eec\u6e05\u9664\u3002

\n

pg_visibility\u6a21\u5757\u53ef\u7528\u4e8e\u68c0\u67e5\u53ef\u89c1\u6027\u6620\u5c04\u4e2d\u5b58\u50a8\u7684\u4fe1\u606f\u3002

\n
", "manual_path": "/docs/devel/storage-vm.html", "localization": {"status": "complete", "sources": [{"url": "/docs/devel/storage-vm.html", "method": "same-major semantic node", "sha256": "5009636a6bc1fa34547b5cc270333bdbc4ad804c5fb622df7dc15c510f71bee2", "language": "zh", "matched_nodes": ["#STORAGE-VM/div[0]", "#STORAGE-VM/p[3]", "#STORAGE-VM/p[4]", "#STORAGE-VM/p[5]", "#STORAGE-VM/p[6]"]}], "language": "zh", "original_text": {"/summary": "Each heap relation has a Visibility Map (VM) to keep track of which pages contain only tuples that are known to be visible to all active transactions; it also keeps track of which pages contain only frozen tuples. It's stored alongside the main relation data in a separate relation fork, named after the filenode number of the relation, plus a _vm suffix. For example, if the filenode of a relation is 12345, the VM is stored in a file called 12345_vm , in the same directory as the main relation file. Note that indexes do not have VMs.", "/category": "Physical structures", "/versions/20/description/0": "Each heap relation has a Visibility Map (VM) to keep track of which pages contain only tuples that are known to be visible to all active transactions; it also keeps track of which pages contain only frozen tuples. It's stored alongside the main relation data in a separate relation fork, named after the filenode number of the relation, plus a _vm suffix. For example, if the filenode of a relation is 12345, the VM is stored in a file called 12345_vm , in the same directory as the main relation file. Note that indexes do not have VMs.", "/versions/20/facts/0/label": "Definition scope", "/versions/20/facts/0/value": "Same-version core physical storage documentation", "/versions/20/related/1/label": "Storage Parameters"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "f933da7657efc9a7f8cf57c34317ba23f259670f72ce1ac3791eca99466b742b"}, "comparison_data": {"layouts": []}, "comparison_hash": "27341929154bfb55531f03501322b65af719c5561f3c4ddc9528a14aa4df69b5", "manual_language": "zh"}}}, "snapshot": {"facts": [{"label": "\u5b9a\u4e49\u8303\u56f4", "value": "\u540c\u7248\u672c\u6838\u5fc3\u7269\u7406\u5b58\u50a8\u6587\u6863"}], "tables": [], "related": [{"url": "/wiki/tableam/?v=18", "label": "Table AM"}, {"url": "/wiki/relopts/?v=18", "label": "\u5b58\u50a8\u53c2\u6570"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "label": "18.6", "major": "18", "channel": "stable", "revision": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "sources": [{"url": "https://pg.center/docs/18/storage-vm.html", "path": "storage-vm.html", "label": "PostgreSQL 18 English manual", "sha256": "26b3512091ad6215922297afdfbf457448a1d6dee9b2df2c69ed5b25cd3df5e0", "language": "en", "original_url": "/docs/18/storage-vm.html"}], "sections": [], "signature": "", "description": ["\u6bcf\u4e2a\u5806\u5173\u7cfb\u90fd\u6709\u4e00\u4e2a\u53ef\u89c1\u6027\u6620\u5c04\uff08VM\uff09\uff0c\u7528\u4e8e\u8ddf\u8e2a\u54ea\u4e9b\u9875\u9762\u53ea\u5305\u542b\u5df2\u77e5\u5bf9\u6240\u6709\u6d3b\u52a8\u4e8b\u52a1\u90fd\u53ef\u89c1\u7684\u5143\u7ec4\uff1b\u5b83\u8fd8\u4f1a\u8ddf\u8e2a\u54ea\u4e9b\u9875\u9762\u53ea\u5305\u542b\u5df2\u51bb\u7ed3\u7684\u5143\u7ec4\u3002\u5b83\u4e0e\u4e3b\u5173\u7cfb\u6570\u636e\u5e76\u5217\u5b58\u653e\u5728\u4e00\u4e2a\u72ec\u7acb\u7684\u5173\u7cfb\u5206\u652f\u4e2d\uff0c\u540d\u79f0\u7531\u5173\u7cfb\u7684\u6587\u4ef6\u8282\u70b9\u7f16\u53f7\u52a0\u4e0a _vm \u540e\u7f00\u6784\u6210\u3002\u4f8b\u5982\uff0c\u5982\u679c\u67d0\u5173\u7cfb\u7684\u6587\u4ef6\u8282\u70b9\u662f 12345\uff0c\u90a3\u4e48 VM \u4f1a\u5b58\u50a8\u5728\u540d\u4e3a 12345_vm \u7684\u6587\u4ef6\u4e2d\uff0c\u4e0e\u4e3b\u5173\u7cfb\u6587\u4ef6\u4f4d\u4e8e\u540c\u4e00\u76ee\u5f55\u3002\u8bf7\u6ce8\u610f\uff0c\u7d22\u5f15\u6ca1\u6709 VM\u3002"], "manual_html": "
\n
\n
\n
\n

\n
\n
\n

66.4.\u00a0\u53ef\u89c1\u6027\u6620\u5c04

\n
\n
\n

\n
\n
\n
\n

\u6bcf\u4e2a\u5806\u5173\u7cfb\u90fd\u6709\u4e00\u4e2a\u53ef\u89c1\u6027\u6620\u5c04\uff08VM\uff09\uff0c\u7528\u4e8e\u8ddf\u8e2a\u54ea\u4e9b\u9875\u9762\u53ea\u5305\u542b\u5df2\u77e5\u5bf9\u6240\u6709\u6d3b\u52a8\u4e8b\u52a1\u90fd\u53ef\u89c1\u7684\u5143\u7ec4\uff1b\u5b83\u8fd8\u4f1a\u8ddf\u8e2a\u54ea\u4e9b\u9875\u9762\u53ea\u5305\u542b\u5df2\u51bb\u7ed3\u7684\u5143\u7ec4\u3002\u5b83\u4e0e\u4e3b\u5173\u7cfb\u6570\u636e\u5e76\u5217\u5b58\u653e\u5728\u4e00\u4e2a\u72ec\u7acb\u7684\u5173\u7cfb\u5206\u652f\u4e2d\uff0c\u540d\u79f0\u7531\u5173\u7cfb\u7684\u6587\u4ef6\u8282\u70b9\u7f16\u53f7\u52a0\u4e0a _vm \u540e\u7f00\u6784\u6210\u3002\u4f8b\u5982\uff0c\u5982\u679c\u67d0\u5173\u7cfb\u7684\u6587\u4ef6\u8282\u70b9\u662f 12345\uff0c\u90a3\u4e48 VM \u4f1a\u5b58\u50a8\u5728\u540d\u4e3a 12345_vm \u7684\u6587\u4ef6\u4e2d\uff0c\u4e0e\u4e3b\u5173\u7cfb\u6587\u4ef6\u4f4d\u4e8e\u540c\u4e00\u76ee\u5f55\u3002\u8bf7\u6ce8\u610f\uff0c\u7d22\u5f15\u6ca1\u6709 VM\u3002

\n

\u53ef\u89c1\u6027\u6620\u5c04\u4e3a\u6bcf\u4e2a\u5806\u9875\u9762\u5b58\u50a8\u4e24\u4e2a\u4f4d\u3002\u7b2c\u4e00\u4f4d\u82e5\u88ab\u7f6e\u4f4d\uff0c\u8868\u793a\u8be5\u9875\u9762\u662f\u5168\u90e8\u53ef\u89c1\uff08all-visible\uff09\uff0c\u6362\u53e5\u8bdd\u8bf4\uff0c\u8be5\u9875\u9762\u4e0d\u5305\u542b\u4efb\u4f55\u9700\u8981\u88ab\u6e05\u7406\u7684\u5143\u7ec4\u3002\u8fd9\u4e9b\u4fe1\u606f\u8fd8\u53ef\u4ee5\u88ab\u4ec5\u7d22\u5f15\u626b\u63cf\u7528\u6765\u53ea\u4f9d\u636e\u7d22\u5f15\u5143\u7ec4\u56de\u7b54\u67e5\u8be2\u3002\u7b2c\u4e8c\u4f4d\u82e5\u88ab\u7f6e\u4f4d\uff0c\u5219\u8868\u793a\u9875\u9762\u4e0a\u7684\u6240\u6709\u5143\u7ec4\u90fd\u5df2\u7ecf\u88ab\u51bb\u7ed3\u3002\u8fd9\u610f\u5473\u7740\uff0c\u5373\u4f7f\u662f\u9632\u56de\u5377\u6e05\u7406\u4e5f\u4e0d\u5fc5\u91cd\u65b0\u8bbf\u95ee\u8be5\u9875\u9762\u3002

\n

\u8fd9\u4e2a\u6620\u5c04\u662f\u4fdd\u5b88\u7684\uff0c\u4e5f\u5c31\u662f\u8bf4\uff0c\u53ea\u8981\u67d0\u4e2a\u4f4d\u88ab\u7f6e\u4f4d\uff0c\u6211\u4eec\u5c31\u80fd\u786e\u5b9a\u76f8\u5e94\u6761\u4ef6\u786e\u5b9e\u6210\u7acb\uff1b\u4f46\u5982\u679c\u67d0\u4e2a\u4f4d\u6ca1\u6709\u7f6e\u4f4d\uff0c\u8be5\u6761\u4ef6\u65e2\u53ef\u80fd\u4e3a\u771f\uff0c\u4e5f\u53ef\u80fd\u4e0d\u4e3a\u771f\u3002\u53ef\u89c1\u6027\u6620\u5c04\u4f4d\u53ea\u4f1a\u7531 VACUUM \u8bbe\u7f6e\uff0c\u4f46\u9875\u9762\u4e0a\u7684\u4efb\u4f55\u6570\u636e\u4fee\u6539\u64cd\u4f5c\u90fd\u4f1a\u628a\u5b83\u4eec\u6e05\u9664\u3002

\n

pg_visibility\u6a21\u5757\u53ef\u7528\u4e8e\u68c0\u67e5\u53ef\u89c1\u6027\u6620\u5c04\u4e2d\u5b58\u50a8\u7684\u4fe1\u606f\u3002

\n
", "manual_path": "/docs/18/storage-vm.html", "localization": {"status": "complete", "sources": [{"url": "/docs/18/storage-vm.html", "method": "same-major semantic node", "sha256": "add821d03c017af92f191665db38e3a6920b430c73c75f2539d825bbce82a373", "language": "zh", "matched_nodes": ["#STORAGE-VM/div[0]", "#STORAGE-VM/p[3]", "#STORAGE-VM/p[4]", "#STORAGE-VM/p[5]", "#STORAGE-VM/p[6]"]}], "language": "zh", "original_text": {"/versions/18/description/0": "Each heap relation has a Visibility Map (VM) to keep track of which pages contain only tuples that are known to be visible to all active transactions; it also keeps track of which pages contain only frozen tuples. It's stored alongside the main relation data in a separate relation fork, named after the filenode number of the relation, plus a _vm suffix. For example, if the filenode of a relation is 12345, the VM is stored in a file called 12345_vm , in the same directory as the main relation file. Note that indexes do not have VMs.", "/versions/18/facts/0/label": "Definition scope", "/versions/18/facts/0/value": "Same-version core physical storage documentation", "/versions/18/related/1/label": "Storage Parameters"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "162e406b7b64fe31e8ce46c31ce1e13e9ca69c4e69f1309fca89ea8fea8a2613"}, "comparison_data": {"layouts": []}, "comparison_hash": "27341929154bfb55531f03501322b65af719c5561f3c4ddc9528a14aa4df69b5", "manual_language": "zh"}, "comparison": {"left": "17", "right": "18", "status": "unchanged", "diff": ""}}