{"Entry":{"collection":"relopts","key":"table-toast-value-type","name":"toast_value_type","aliases":["table.toast_value_type"],"metadata":{"aliases":["table.toast_value_type"],"category":"Tables and materialized views","content_hash":"bb44d57cdfd8c0bdcc7e470236238d16514661569a37da1edeac6426b1d62e61","imported_at":"2026-09-30T17:44:22.261913+08:00","name":"toast_value_type","name_zh":"toast_value_type","slug":"table-toast-value-type","summary":"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."}},"Definition":{"Collection":"relopts","Key":"table-toast-value-type","SourceDatabase":"center","Version":"20","SourceTable":"relopt","SourceKey":"table-toast-value-type","SourceRevision":"ca199fbaaf6c4bd29cd5a98beaf34d9f4141c15d2f94d1d0202f3204ef18d09f","Facts":{"description":["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."],"facts":[{"label":"Applies to","value":"Tables and materialized views"},{"label":"Value type","value":"enum"}],"related":[{"label":"CREATE TABLE","url":"/wiki/sql/create-table/?v=20"}],"release":{"channel":"devel","label":"20 devel","major":"20","ref":"2c10c2ce4d7bcd57543a49ab402af02a39724e0a","revision":"ca199fbaaf6c4bd29cd5a98beaf34d9f4141c15d2f94d1d0202f3204ef18d09f"},"sections":[{"paragraphs":["This relation-level setting applies to the table or materialized view. Any corresponding global parameter has a separate entry."],"title":"Scope"},{"paragraphs":["The WITH clause can specify storage parameters for tables, and for indexes associated with a UNIQUE , PRIMARY KEY , or EXCLUDE constraint. Storage parameters for indexes are documented in CREATE INDEX . The storage parameters currently available for tables are listed below. For many of these parameters, as shown, there is an additional parameter with the same name prefixed with toast. , which controls the behavior of the table's secondary TOAST table, if any (see Section 66.2 for more information about TOAST). If a table parameter value is set and the equivalent toast. parameter is not, the TOAST table will use the table's parameter value. Specifying these parameters for partitioned tables is not supported, but you may specify them for individual leaf partitions."],"title":"Common table storage rules"},{"paragraphs":["This clause specifies optional storage parameters for the new materialized view; see Storage Parameters in the CREATE TABLE documentation for more information. All parameters supported for CREATE TABLE are also supported for CREATE MATERIALIZED VIEW . See CREATE TABLE for more information."],"title":"Materialized views"}],"signature":"WITH (toast_value_type = value)","sources":[{"label":"PostgreSQL 20 English manual","path":"sql-createtable.html","sha256":"5241bd673de4e7a8fec7db6fa2a3a50d8368965206170725c4efd15d64c3fbf2","url":"/docs/devel/sql-createtable.html#RELOPTION-TOAST-VALUE-TYPE"},{"label":"PostgreSQL 20 English manual","path":"sql-creatematerializedview.html","sha256":"2870e714f1d3ef3bb692310424bb0e8fc1905c7b4a46317c5be883c70daa90c2","url":"/docs/devel/sql-creatematerializedview.html"}]},"ManualEvidence":{"release":{"channel":"devel","label":"20 devel","major":"20","ref":"2c10c2ce4d7bcd57543a49ab402af02a39724e0a","revision":"ca199fbaaf6c4bd29cd5a98beaf34d9f4141c15d2f94d1d0202f3204ef18d09f"},"sources":[{"label":"PostgreSQL 20 English manual","path":"sql-createtable.html","sha256":"5241bd673de4e7a8fec7db6fa2a3a50d8368965206170725c4efd15d64c3fbf2","url":"/docs/devel/sql-createtable.html#RELOPTION-TOAST-VALUE-TYPE"},{"label":"PostgreSQL 20 English manual","path":"sql-creatematerializedview.html","sha256":"2870e714f1d3ef3bb692310424bb0e8fc1905c7b4a46317c5be883c70daa90c2","url":"/docs/devel/sql-creatematerializedview.html"}]},"MeasuredEvidence":{}},"Text":{"Collection":"relopts","Key":"table-toast-value-type","SourceDatabase":"center","Version":"20","Locale":"en","Title":"toast_value_type","Summary":"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.\nThe 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.","BodyHTML":"\u003cp\u003eSpecifies 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.\nThe 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.\u003c/p\u003e","SourceRevision":"ca199fbaaf6c4bd29cd5a98beaf34d9f4141c15d2f94d1d0202f3204ef18d09f","ContentHash":"132c7400eb99db28e2417a1022cb418bf5844e6668a5259416e9b993472f43cb","Payload":{"description":["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."],"related":[{"label":"CREATE TABLE","url":"/wiki/sql/create-table/?v=20"}],"sections":[{"paragraphs":["This relation-level setting applies to the table or materialized view. Any corresponding global parameter has a separate entry."],"title":"Scope"},{"paragraphs":["The WITH clause can specify storage parameters for tables, and for indexes associated with a UNIQUE , PRIMARY KEY , or EXCLUDE constraint. Storage parameters for indexes are documented in CREATE INDEX . The storage parameters currently available for tables are listed below. For many of these parameters, as shown, there is an additional parameter with the same name prefixed with toast. , which controls the behavior of the table's secondary TOAST table, if any (see Section 66.2 for more information about TOAST). If a table parameter value is set and the equivalent toast. parameter is not, the TOAST table will use the table's parameter value. Specifying these parameters for partitioned tables is not supported, but you may specify them for individual leaf partitions."],"title":"Common table storage rules"},{"paragraphs":["This clause specifies optional storage parameters for the new materialized view; see Storage Parameters in the CREATE TABLE documentation for more information. All parameters supported for CREATE TABLE are also supported for CREATE MATERIALIZED VIEW . See CREATE TABLE for more information."],"title":"Materialized views"}]}},"RequestedLocale":"zh-Hans","Fallback":true,"Versions":["20"],"Locales":["en"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}