↑↓ 选择↵ 打开⌫ 切换范围完整搜索

PG.CENTER 连接 PostgreSQL 文档、百科与生态知识。由 Pigsty 维护。

Wiki / 存储参数

toast_value_type

Specifies the attribute type of chunk_id to use when creating a TOAST relation for this table. The default is oid ; oid8 assigns oid8 instead, which allows a larger number of distinct TOAST ed values at the price of four extra bytes per out-of-line pointer. This parameter cannot be set for TOAST tables. The value is only consulted when the TOAST relation is created. Changing it afterwards has no effect on an existing TOAST relation, and a table rewrite such as CLUSTER , REPACK or VACUUM FULL preserves the type already in use. A dump and restore, on the other hand, recreates the TOAST relation and therefore applies the current value of this parameter.

当前阅读 PG 20·选择有来源记录的版本

此版本暂无所选语言的定义,以下显示原始英文内容。

Applies to
Tables and materialized views
Value type
enum
signature
WITH (toast_value_type = value)

版本定义 PG 20

Specifies the attribute type of chunk_id to use when creating a TOAST relation for this table. The default is oid ; oid8 assigns oid8 instead, which allows a larger number of distinct TOAST ed values at the price of four extra bytes per out-of-line pointer. This parameter cannot be set for TOAST tables. The value is only consulted when the TOAST relation is created. Changing it afterwards has no effect on an existing TOAST relation, and a table rewrite such as CLUSTER , REPACK or VACUUM FULL preserves the type already in use. A dump and restore, on the other hand, recreates the TOAST relation and therefore applies the current value of this parameter.

比较版本

来源引用

完整定义与证据 JSON

定义来源

center · PostgreSQL 20 · ca199fbaaf6c4bd29cd5a98beaf34d9f4141c15d2f94d1d0202f3204ef18d09f

正文语言: en · ca199fbaaf6c4bd29cd5a98beaf34d9f4141c15d2f94d1d0202f3204ef18d09f