diff options
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/catalogs.sgml | 10 | ||||
| -rw-r--r-- | doc/src/sgml/ref/alter_table.sgml | 18 | ||||
| -rw-r--r-- | doc/src/sgml/ref/create_table.sgml | 4 |
3 files changed, 25 insertions, 7 deletions
diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml index 29817fb33c6..096ddab481c 100644 --- a/doc/src/sgml/catalogs.sgml +++ b/doc/src/sgml/catalogs.sgml @@ -1988,9 +1988,13 @@ SCRAM-SHA-256$<replaceable><iteration count></replaceable>:<replaceable>&l (references <link linkend="catalog-pg-am"><structname>pg_am</structname></link>.<structfield>oid</structfield>) </para> <para> - If this is a table or an index, the access method used (heap, - B-tree, hash, etc.); otherwise zero (zero occurs for sequences, - as well as relations without storage, such as views) + The access method used to access this table or index. + Not meaningful if the relation is a sequence or + has no on-disk file, + except for partitioned tables, where, if set, it takes + precedence over <varname>default_table_access_method</varname> + when determining the access method to use for partitions created + when one is not specified in the creation command. </para></entry> </row> diff --git a/doc/src/sgml/ref/alter_table.sgml b/doc/src/sgml/ref/alter_table.sgml index 96e3d776051..6cdcd779ef8 100644 --- a/doc/src/sgml/ref/alter_table.sgml +++ b/doc/src/sgml/ref/alter_table.sgml @@ -732,10 +732,20 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM <term><literal>SET ACCESS METHOD</literal></term> <listitem> <para> - This form changes the access method of the table by rewriting it. See - <xref linkend="tableam"/> for more information. Writing - <literal>DEFAULT</literal> changes the access method of the table - to <xref linkend="guc-default-table-access-method"/>. + This form changes the access method of the table by rewriting it + using the indicated access method; specifying + <literal>DEFAULT</literal> selects the access method set as the + <xref linkend="guc-default-table-access-method"/> configuration + parameter. + See <xref linkend="tableam"/> for more information. + </para> + <para> + When applied to a partitioned table, there is no data to rewrite, + but partitions created afterwards will default to the given access + method unless overridden by a <literal>USING</literal> clause. + Specifying <varname>DEFAULT</varname> removes a previous value, + causing future partitions to default to + <varname>default_table_access_method</varname>. </para> </listitem> </varlistentry> diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml index 118c7053e60..dfb7822985e 100644 --- a/doc/src/sgml/ref/create_table.sgml +++ b/doc/src/sgml/ref/create_table.sgml @@ -1365,6 +1365,10 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM method is chosen for the new table. See <xref linkend="guc-default-table-access-method"/> for more information. </para> + <para> + When creating a partition, the table access method is the access method + of its partitioned table, if set. + </para> </listitem> </varlistentry> |