Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit56d467a

Browse files
committed
doc: PG 14 relnotes, mention CONCURRENTLY improvements
Add items for vacuum not having to wait for CONCURRENTLY, andCONCURRENTLY not having to wait for other CONCURRENTLY operations.Reported-by: Simon RiggsDiscussion:https://postgr.es/m/CANbhV-EMM4nf7Ys-Yae_kY25dXT_3eiOXke2+yw44jgy+4jNsA@mail.gmail.comBackpatch-through: 14 only
1 parenta3a681f commit56d467a

File tree

1 file changed

+39
-0
lines changed

1 file changed

+39
-0
lines changed

‎doc/src/sgml/release-14.sgml

Lines changed: 39 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -744,6 +744,28 @@ Author: Peter Geoghegan <pg@bowt.ie>
744744

745745
<listitem>
746746
<!--
747+
Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
748+
2020-11-25 [c98763bf5] Avoid spurious waits in concurrent indexing
749+
Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
750+
2021-01-15 [f9900df5f] Avoid spurious wait in concurrent reindex
751+
Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
752+
2021-02-23 [d9d076222] VACUUM: ignore indexing operations with CONCURRENTLY
753+
-->
754+
755+
<para>
756+
Allow vacuum to be more aggressive in removing dead rows during
757+
minimal-locking index operations (Álvaro Herrera)
758+
</para>
759+
760+
<para>
761+
Specifically, <command>CREATE INDEX CONCURRENTLY</command> and
762+
<command>REINDEX CONCURRENTLY</command> no longer limit the dead
763+
row removal of other relations.
764+
</para>
765+
</listitem>
766+
767+
<listitem>
768+
<!--
747769
Author: Fujii Masao <fujii@postgresql.org>
748770
2020-12-08 [e2ac3fed3] Speed up rechecking if relation needs to be vacuumed or
749771
-->
@@ -2283,6 +2305,23 @@ Author: Michael Paquier <michael@paquier.xyz>
22832305
</para>
22842306
</listitem>
22852307

2308+
<listitem>
2309+
<!--
2310+
Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
2311+
2020-11-25 [c98763bf5] Avoid spurious waits in concurrent indexing
2312+
Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
2313+
2021-01-15 [f9900df5f] Avoid spurious wait in concurrent reindex
2314+
Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
2315+
2021-02-23 [d9d076222] VACUUM: ignore indexing operations with CONCURRENTLY
2316+
-->
2317+
2318+
<para>
2319+
Allow index commands using <command>CONCURRENTLY</command> to
2320+
avoid waiting for the completion of other operations using
2321+
<command>CONCURRENTLY</command> (Álvaro Herrera)
2322+
</para>
2323+
</listitem>
2324+
22862325
<listitem>
22872326
<!--
22882327
Author: Tom Lane <tgl@sss.pgh.pa.us>

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp