Home • Explore • Blog • CI
☰



postgresql
18th chunk of `doc/src/sgml/release-18.sgml`
bdbb85087e118df8c65bb58b90f33d19de2c2bdb1a5d10120000000100000fce

<para>
Add REJECT_LIMIT to control the number of invalid rows COPY FROM can ignore (Atsushi Torikoshi)
<ulink url="&commit_baseurl;4ac2a9bec">&sect;</ulink>
</para>

<para>
This is available when ON_ERROR = 'ignore'.
</para>
</listitem>

<!--
Author: Fujii Masao <fujii@postgresql.org>
2025-04-04 [534874fac] Allow "COPY table TO" command to copy rows from material
-->

<listitem>
<para>
Allow COPY TO to copy rows from populated materialized view (Jian He)
<ulink url="&commit_baseurl;534874fac">&sect;</ulink>
</para>
</listitem>

<!--
Author: Fujii Masao <fujii@postgresql.org>
2024-10-03 [e7834a1a2] Add LOG_VERBOSITY = 'silent' support to COPY command.
-->

<listitem>
<para>
Add COPY LOG_VERBOSITY level "silent" to suppress log output of ignored rows (Atsushi Torikoshi)
<ulink url="&commit_baseurl;e7834a1a2">&sect;</ulink>
</para>

<para>
This new level suppresses output for discarded input rows when on_error = 'ignore'.
</para>
</listitem>

<!--
Author: Nathan Bossart <nathan@postgresql.org>
2025-02-06 [401a6956f] Disallow COPY FREEZE on foreign tables.
-->

<listitem>
<para>
Disallow COPY FREEZE on foreign tables (Nathan Bossart)
<ulink url="&commit_baseurl;401a6956f">&sect;</ulink>
</para>

<para>
Previously, the COPY worked but the FREEZE was ignored, so disallow this command.
</para>
</listitem>

     </itemizedlist>
    </sect4>

    <sect4 id="release-18-explain">
     <title><link linkend="sql-explain"><command>EXPLAIN</command></link></title>

     <itemizedlist>

<!--
Author: David Rowley <drowley@postgresql.org>
2024-12-11 [c2a4078eb] Enable BUFFERS with EXPLAIN ANALYZE by default
-->

<listitem>
<para>
Automatically include BUFFERS output in EXPLAIN ANALYZE (Guillaume Lelarge, David Rowley)
<ulink url="&commit_baseurl;c2a4078eb">&sect;</ulink>
</para>
</listitem>

<!--
Author: Michael Paquier <michael@paquier.xyz>
2025-02-17 [320545bfc] Add information about WAL buffers being full to EXPLAIN
-->

<listitem>
<para>
Add full WAL buffer count to EXPLAIN (WAL) output (Bertrand Drouvot)
<ulink url="&commit_baseurl;320545bfc">&sect;</ulink>
</para>
</listitem>

<!--
Author: Peter Geoghegan <pg@bowt.ie>
2025-03-11 [0fbceae84] Show index search count in EXPLAIN ANALYZE, take 2.
-->

<listitem>
<para>
In EXPLAIN ANALYZE, report the number of index lookups used per index scan node (Peter Geoghegan)
<ulink url="&commit_baseurl;0fbceae84">&sect;</ulink>
</para>
</listitem>

<!--
Author: Robert Haas <rhaas@postgresql.org>
2025-02-21 [ddb17e387] Allow EXPLAIN to indicate fractional rows.
Author: Robert Haas <rhaas@postgresql.org>
2025-02-27 [95dbd827f] EXPLAIN: Always use two fractional digits for row counts
-->

<listitem>
<para>
Modify EXPLAIN to output fractional row counts (Ibrar Ahmed, Ilia Evdokimov, Robert Haas)
<ulink url="&commit_baseurl;ddb17e387">&sect;</ulink>
<ulink url="&commit_baseurl;95dbd827f">&sect;</ulink>
</para>
</listitem>

<!--
Author: David Rowley <drowley@postgresql.org>
2024-07-05 [1eff8279d] Add memory/disk usage for Material nodes in EXPLAIN
Author: David Rowley <drowley@postgresql.org>
2024-07-05 [53abb1e0e] Fix newly introduced issue in EXPLAIN for Materialize no
Author: Tatsuo Ishii <ishii@postgresql.org>
2024-09-17 [95d6e9af0] Add memory/disk usage for Window aggregate nodes in EXPL
Author: Tatsuo Ishii <ishii@postgresql.org>
2024-09-23 [40708acd6] Add memory/disk usage for more executor nodes.
-->

<listitem>
<para>
Add memory and disk usage details to Material, Window Aggregate, and common table expression nodes in EXPLAIN (David Rowley, Tatsuo Ishii)
<ulink url="&commit_baseurl;1eff8279d">&sect;</ulink>
<ulink url="&commit_baseurl;53abb1e0e">&sect;</ulink>
<ulink url="&commit_baseurl;95d6e9af0">&sect;</ulink>
<ulink url="&commit_baseurl;40708acd6">&sect;</ulink>
</para>
</listitem>


<!--
Author: Tom Lane <tgl@sss.pgh.pa.us>
2025-03-11 [8b1b34254] Improve EXPLAIN's display of window functions.
-->

<listitem>
<para>
Add details about window function arguments to EXPLAIN output (Tom Lane)
<ulink url="&commit_baseurl;8b1b34254">&sect;</ulink>
Title: PostgreSQL 18: COPY Command Updates and EXPLAIN Enhancements
Summary
This section details updates to the COPY command, including adding REJECT_LIMIT to control the number of invalid rows COPY FROM can ignore, allowing COPY TO to copy rows from populated materialized views, adding COPY LOG_VERBOSITY level 'silent' to suppress log output of ignored rows, and disallowing COPY FREEZE on foreign tables. It also covers enhancements to EXPLAIN, such as automatically including BUFFERS output in EXPLAIN ANALYZE, adding full WAL buffer count to EXPLAIN (WAL) output, reporting the number of index lookups used per index scan node, outputting fractional row counts, adding memory and disk usage details to Material, Window Aggregate, and common table expression nodes, and adding details about window function arguments to EXPLAIN output.