</listitem>

</varlistentry>

<varlistentry>

<varlistentry id="sql-altertable-attach-partition">

<term><literal>ATTACH PARTITION <replaceable class="parameter">partition_name</replaceable> { FOR VALUES <replaceable class="parameter">partition_bound_spec</replaceable> | DEFAULT }</literal></term>

<listitem>

<para>

<para>

Partitioning performance enhancements, including improved query

performance on tables with thousands of partitions, improved

insertion performance with <xref linkend="sql-insert"/> and

<xreflinkend="sql-copy"/>, and the ability to

execute <linklinkend="sql-altertable"><command>ALTER TABLE ATTACH

insertion performance with <xref linkend="sql-insert"/> and <xref

linkend="sql-copy"/>, and the ability to execute <link

linkend="sql-altertable-attach-partition"><command>ALTER TABLE ATTACH

PARTITION</command></link> without blocking queries

</para>

</listitem>

<itemizedlist>

<listitem>

<para>

<link linkend="sql-reindex"><command>REINDEX

<link linkend="sql-reindex-concurrently"><command>REINDEX

CONCURRENTLY</command></link> can rebuild an index without

blocking writes to its table

</para>

<listitem>

<para>

Support for the <acronym>SQL/JSON</acronym>

<link linkend="functions-sqljson-path">path</link> language

Support for the <link

linkend="functions-sqljson-path"><acronym>SQL/JSON</acronym>

path</link> language

</para>

</listitem>

<listitem>

<para>

Nondeterministic ICU

<link linkend="collation">collations</link>, enabling

case-insensitive and accent-insensitive groupingand ordering

<link linkend="collation-nondeterministic">Nondeterministic</link> ICU

collations, enabling case-insensitive and accent-insensitive grouping

and ordering

</para>

</listitem>

Previously, a normally-invisible <structfield>oid</structfield>

column could be specified during table creation using <literal>WITH

OIDS</literal>; that ability has been removed. Columns can still be

explicitly declared as type <type>OID</type>. Operations on tables

explicitly declared as type <type>oid</type>. Operations on tables

that have columns created using <literal>WITH OIDS</literal> will

need adjustment.

</para>

<para>

Allow <command>VACUUM</command> and <command>ANALYZE</command>

to take optionalboolean argument specifications (Masahiko Sawada)

to take optionalBoolean argument specifications (Masahiko Sawada)

</para>

</listitem>