Commit29c18bc

committed

Add mention of ANALYZE after object restore.

1 parentccfa6f1 commit29c18bcCopy full SHA for 29c18bc

File tree

+37

-6

lines changed

+37

-6

lines changed

Lines changed: 8 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -1,5 +1,5 @@`
`1`	`1`	`<!--`
`2`		`-$Header: /cvsroot/pgsql/doc/src/sgml/backup.sgml,v 2.24 2002/11/11 20:14:02 petere Exp $`
	`2`	`+$Header: /cvsroot/pgsql/doc/src/sgml/backup.sgml,v 2.25 2003/03/18 00:02:11 momjian Exp $`
`3`	`3`	`-->`
`4`	`4`	`<chapter id="backup">`
`5`	`5`	`<title>Backup and Restore</title>`
`@@ -125,6 +125,13 @@ psql <replaceable class="parameter">dbname</replaceable> < <replaceable class`
`125`	`125`	`authentication settings.`
`126`	`126`	`</para>`
`127`	`127`
	`128`	`+ <para>`
	`129`	`+ Once restored, it is wise to run <command>ANALYZE</> on each`
	`130`	`+ database so the optimizer has useful statistics. You`
	`131`	`+ can also run <command>vacuumdb -a -z</> to <command>ANALYZE</> all`
	`132`	`+ databases.`
	`133`	`+ </para>`
	`134`	`+`
`128`	`135`	`<para>`
`129`	`136`	`The ability of <application>pg_dump</> and <application>psql</> to`
`130`	`137`	`write to or read from pipes makes it possible to dump a database`

Lines changed: 12 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -1,5 +1,5 @@`
`1`	`1`	`<!--`
`2`		`-$Header: /cvsroot/pgsql/doc/src/sgml/ref/pg_dump.sgml,v 1.56 2003/02/13 04:54:15 momjian Exp $`
	`2`	`+$Header: /cvsroot/pgsql/doc/src/sgml/ref/pg_dump.sgml,v 1.57 2003/03/18 00:02:11 momjian Exp $`
`3`	`3`	`PostgreSQL documentation`
`4`	`4`	`-->`
`5`	`5`
`@@ -650,6 +650,11 @@ CREATE DATABASE foo WITH TEMPLATE template0;`
`650`	`650`	`</programlisting>`
`651`	`651`	`</para>`
`652`	`652`
	`653`	`+ <para>`
	`654`	`+ Once restored, it is wise to run <command>ANALYZE</> on each`
	`655`	`+ restored object so the optimizer has useful statistics.`
	`656`	`+ </para>`
	`657`	`+`
`653`	`658`	`<para>`
`654`	`659`	`<application>pg_dump</application> has a few limitations:`
`655`	`660`
`@@ -682,6 +687,12 @@ CREATE DATABASE foo WITH TEMPLATE template0;`
`682`	`687`	`other output formats is not limited, except possibly by the`
`683`	`688`	`operating system.`
`684`	`689`	`</para>`
	`690`	`+`
	`691`	`+ <para>`
	`692`	`+ Once restored, it is wise to run <command>ANALYZE</> on each`
	`693`	`+ restored object so the optimizer has useful statistics.`
	`694`	`+ </para>`
	`695`	`+`
`685`	`696`	`</refsect1>`
`686`	`697`
`687`	`698`	`<refsect1 id="pg-dump-examples">`

Lines changed: 10 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,5 +1,5 @@`
`1`	`1`	`<!--`
`2`		`-$Header: /cvsroot/pgsql/doc/src/sgml/ref/pg_dumpall.sgml,v 1.36 2003/01/06 18:53:24 petere Exp $`
	`2`	`+$Header: /cvsroot/pgsql/doc/src/sgml/ref/pg_dumpall.sgml,v 1.37 2003/03/18 00:02:11 momjian Exp $`
`3`	`3`	`PostgreSQL documentation`
`4`	`4`	`-->`
`5`	`5`
`@@ -258,10 +258,17 @@ PostgreSQL documentation`
`258`	`258`	`<application>pg_dumpall</application> will need to connect several`
`259`	`259`	`times to the <productname>PostgreSQL</productname> server. If password`
`260`	`260`	`authentication is configured, it will ask for a password each time. In`
`261`		`- that case it would be convenient to set up a password file.`
	`261`	`+ that case it would be convenient to set up a <filename>.pgpass</>`
	`262`	`+ password file.`
	`263`	`+ </para>`
	`264`	`+`
	`265`	`+ <para>`
	`266`	`+ Once restored, it is wise to run <command>ANALYZE</> on each`
	`267`	`+ database so the optimizer has useful statistics. You`
	`268`	`+ can also run <command>vacuumdb -a -z</> to <command>ANALYZE</> all`
	`269`	`+ databases.`
`262`	`270`	`</para>`
`263`	`271`
`264`		`- <comment>But where is that password file documented?</comment>`
`265`	`272`	`</refsect1>`
`266`	`273`
`267`	`274`

Lines changed: 7 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -1,4 +1,4 @@`
`1`		`-<!-- $Header: /cvsroot/pgsql/doc/src/sgml/ref/pg_restore.sgml,v 1.35 2003/01/19 00:13:31 momjian Exp $ -->`
	`1`	`+<!-- $Header: /cvsroot/pgsql/doc/src/sgml/ref/pg_restore.sgml,v 1.36 2003/03/18 00:02:11 momjian Exp $ -->`
`2`	`2`
`3`	`3`	`<refentry id="APP-PGRESTORE">`
`4`	`4`	`<docinfo>`
`@@ -589,6 +589,12 @@ CREATE DATABASE foo WITH TEMPLATE = template0;`
`589`	`589`	`See also the <xref linkend="app-pgdump"> documentation for details on`
`590`	`590`	`limitations of <application>pg_dump</application>.`
`591`	`591`	`</para>`
	`592`	`+`
	`593`	`+ <para>`
	`594`	`+ Once restored, it is wise to run <command>ANALYZE</> on each`
	`595`	`+ restored object so the optimizer has useful statistics.`
	`596`	`+ </para>`
	`597`	`+`
`592`	`598`	`</refsect1>`
`593`	`599`
`594`	`600`

Comments

(0)