Commitc0fcf07

committed

doc, pg_upgrade: add vacuumdb w/ tips for generating quick stats

1 parent5134e9d commitc0fcf07Copy full SHA for c0fcf07

File tree

+11

-0

lines changed

+11

-0

lines changed

Lines changed: 11 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -784,6 +784,17 @@ psql --username=postgres --file=script.sql postgres`
`784`	`784`	`of the upgrade. You might need to set connection parameters to`
`785`	`785`	`match your new cluster.`
`786`	`786`	`</para>`
	`787`	`+`
	`788`	`+ <para>`
	`789`	`+ Using <command>vacuumdb --all --analyze-only</command> can efficiently`
	`790`	`+ generate such statistics, and the use of <option>--jobs</option>`
	`791`	`+ can speed it up. Option <option>--analyze-in-stages</option>`
	`792`	`+ can be used to generate minimal statistics quickly.`
	`793`	`+ If <varname>vacuum_cost_delay</varname> is set to a non-zero`
	`794`	`+ value, this can be overridden to speed up statistics generation`
	`795`	`+ using <envar>PGOPTIONS</envar>, e.g., <literal>PGOPTIONS='-c`
	`796`	`+ vacuum_cost_delay=0' vacuumdb ...</literal>.`
	`797`	`+ </para>`
`787`	`798`	`</step>`
`788`	`799`
`789`	`800`	`<step>`

Comments

(0)