NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commita5e169a

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 parent257ee34 commita5e169aCopy full SHA for a5e169a

File tree

1 file changed

-6

lines changed

doc/src/sgml
- maintenance.sgml

1 file changed

-6

lines changed

`‎doc/src/sgml/maintenance.sgml`

Lines changed: 5 additions & 6 deletions

Original file line number	Diff line number	Diff line change
`@@ -606,14 +606,13 @@ SELECT datname, age(datfrozenxid) FROM pg_database;`
`606`	`606`	`</para>`
`607`	`607`
`608`	`608`	`<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:`
`613`	`612`
`614`	`613`	`<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.`
`617`	`616`	`</programlisting>`
`618`	`617`
`619`	`618`	`(A manual <command>VACUUM</command> should fix the problem, as suggested by the`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

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

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commita5e169a

File tree

1 file changed

1 file changed

`‎doc/src/sgml/maintenance.sgml`

0 commit comments