-->

<para>

In ltree, when using adjacent asterisks with braces, e.g. "*{2}.*{3}", properly interpret that as "*{5}" (Nikita Glukhov)

In ltree, when using adjacent asterisks with braces, e.g. ".*{2}.*{3}", properly interpret that as ".*{5}" (Nikita Glukhov)

</para>

</listitem>

<para>

For example, partitionwise joins can now happen between partitioned

tableswhere the ancestorsdo notexactlymatch.

tableseven when their partition boundsdo not match exactly.

</para>

</listitem>

<para>

Previously, partitions had to be replicated individually. Now partitioned tables can be published explicitly causing all partitions to be automatically published. Addition/removal of partitions from

partitioned tables are automatically added/removed from publications. The CREATE PUBLICATION option publish_via_partition_root controls whetherpartitioned tablesare published as their own or theirancestors.

partitioned tables are automatically added/removed from publications. The CREATE PUBLICATION option publish_via_partition_root controls whetherchanges to partitionsare published as their own or theirancestor's.

</para>

</listitem>

More efficiently store duplicates in btree indexes (Anastasia Lubennikova, Peter Geoghegan)

</para>

<para>

This allows efficient btree indexing of low cardinality columns.

Users upgrading with pg_upgrade will need to use REINDEX to make use of

this feature.

</para>

</listitem>

<listitem>

Allow CREATE INDEX to specify the GiST signature length and maximum number of integer ranges (Nikita Glukhov)

</para>

<para>

Indexes created on four and eight-byte integer array, tsvector, trigram,

ltree, and hstore columns can now control these GiST index parameters,

rather than using the defaults.

</para>

</listitem>

<listitem>

</para>

<para>

This new behavior allows pages to be set as all-visible, which then allowsindex-only scans, and reduces the work necessary when the table needs to be frozen.

This new behaviorreduces the work necessary when the table needs to be frozen andallows pages to be set as all-visible. All-visible pages allowindex-only scans to access fewer heap rows.

</para>

</listitem>

-->

<para>

Add system view pg_stat_progress_analyze to report analyze progress (&Aacute;lvaro Herrera, Tatsuro Yamada)

Add system view pg_stat_progress_analyze to report analyze progress (&Aacute;lvaro Herrera, Tatsuro Yamada, Vinayak Pokale)

</para>

</listitem>

Add system view pg_shmem_allocations to display shared memory usage (Andres Freund, Robert Haas)

</para>

<para>

WHAT IS THE ENTRY WITH NO NAME?

</para>

</listitem>

<listitem>

Allow allow_system_table_mods to be changed after server start (Peter Eisentraut)

</para>

<para>

Previously, this could only be set at server start.

</para>

</listitem>

<listitem>

-->

<para>

Allow Unicode escapes, e.g., E'\u####', in databases that do not use UTF-8 encoding (Tom Lane)

Allow Unicode escapes, e.g., E'\u####', U&amp;'\####', to represent any

character available in the database encoding, even when the database

encoding is not UTF-8 (Tom Lane)

</para>

<para>

Add psql commands to report operator classes and operator families (Sergey Cherkashin, Nikita Glukhov, Alexander Korotkov)

</para>

<para>

The new commands are \dAc, \dAf, \dAo, and \dAp.

</para>

</listitem>

<listitem>

</listitem>

<listitem>

<!--

Author: Peter Eisentraut <peter@eisentraut.org>

2020-03-29 [e1ff78048] Document color support

-->

<para>

Document color support (Peter Eisentraut)

</para>

<para>

THIS WAS NOT DOCUMENTED BEFORE?

</para>

</listitem>

<listitem>

<!--

Author: Michael Paquier <michael@paquier.xyz>

</listitem>

<listitem>

<!--

Author: Michael Paquier <michael@paquier.xyz>

2020-02-19 [e2e02191e] Clean up some code, comments and docs referring to Windo

-->

<para>

Remove support for Windows 2000 (Michael Paquier)

</para>

</listitem>

<listitem>

<!--

Author: Peter Eisentraut <peter@eisentraut.org>