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

Commit96879a0

Browse files
committed
Fix documentation of "must be vacuumed within" warning.
Warnings start 10M transactions before xidStopLimit, which is 11Mtransactions before wraparound. The sample WARNING output showed avalue greater than 11M, and its HINT message predated commit25ec228. Hence, the sample wasimpossible. Back-patch to 9.5 (all supported versions).
1 parente1cc25f commit96879a0

File tree

1 file changed

+5
-6
lines changed

1 file changed

+5
-6
lines changed

‎doc/src/sgml/maintenance.sgml

Lines changed: 5 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -606,14 +606,13 @@ SELECT datname, age(datfrozenxid) FROM pg_database;
606606
</para>
607607

608608
<para>
609-
If for some reason autovacuum fails to clear old XIDs from a table,
610-
the system will begin to emit warning messages like this when the
611-
database's oldest XIDs reach ten million transactions from the wraparound
612-
point:
609+
If for some reason autovacuum fails to clear old XIDs from a table, the
610+
system will begin to emit warning messages like this when the database's
611+
oldest XIDs reach eleven million transactions from the wraparound point:
613612

614613
<programlisting>
615-
WARNING: database "mydb" must be vacuumed within177009986 transactions
616-
HINT: To avoid a database shutdown, execute a database-wide VACUUM in"mydb".
614+
WARNING: database "mydb" must be vacuumed within10985967 transactions
615+
HINT: To avoid a database shutdown, execute a database-wide VACUUM inthat database.
617616
</programlisting>
618617

619618
(A manual <command>VACUUM</command> should fix the problem, as suggested by the

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp