diff options
author | Tom Lane <tgl@sss.pgh.pa.us> | 1999-11-28 02:17:43 +0000 |
---|---|---|
committer | Tom Lane <tgl@sss.pgh.pa.us> | 1999-11-28 02:17:43 +0000 |
commit | fb55fa04786a759befb356e404b29a25c72d0f8a (patch) | |
tree | 6cbb17d86bff30d12234f6682bb9b4b843575820 | |
parent | aa903cf07c80093dde1c7b19187911e7ada094b8 (diff) | |
download | postgresql-fb55fa04786a759befb356e404b29a25c72d0f8a.tar.gz postgresql-fb55fa04786a759befb356e404b29a25c72d0f8a.zip |
Remove obsolete note about pg_vlock lock file.
-rw-r--r-- | doc/src/sgml/ref/vacuum.sgml | 12 | ||||
-rw-r--r-- | src/bin/pgaccess/lib/help/vacuum.hlp | 2 |
2 files changed, 1 insertions, 13 deletions
diff --git a/doc/src/sgml/ref/vacuum.sgml b/doc/src/sgml/ref/vacuum.sgml index 87666f47276..e7761397a0f 100644 --- a/doc/src/sgml/ref/vacuum.sgml +++ b/doc/src/sgml/ref/vacuum.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/vacuum.sgml,v 1.5 1999/07/22 15:09:15 thomas Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/vacuum.sgml,v 1.6 1999/11/28 02:17:04 tgl Exp $ Postgres documentation --> @@ -184,16 +184,6 @@ NOTICE: Index <replaceable class="PARAMETER">index</replaceable>: Pages 28; recent changes, and allow the <productname>Postgres</productname> query optimizer to make better choices in planning user queries. </para> - <para> - If the server crashes during a <command>VACUUM</command> command, - chances are it will leave a lock file hanging around. - Attempts to re-run the <command>VACUUM</command> command - result in an error message about the creation of a lock file. If you - are sure <command>VACUUM</command> is not running, - remove the <filename>pg_vlock</filename> file in your - database directory - (i.e. <filename><envar>PGDATA</envar>/base/dbname/pg_vlock</filename>). - </para> </refsect2> </refsect1> diff --git a/src/bin/pgaccess/lib/help/vacuum.hlp b/src/bin/pgaccess/lib/help/vacuum.hlp index ec98382580e..cbdf3551611 100644 --- a/src/bin/pgaccess/lib/help/vacuum.hlp +++ b/src/bin/pgaccess/lib/help/vacuum.hlp @@ -7,8 +7,6 @@ VACUUM opens every class in the database, cleans out records from rolled back tr We recommend that active production databases be cleaned nightly, in order to keep statistics relatively current. The VACUUM query may be executed at any time, however. In particular, after copying a large class into Postgres or after deleting a large number of records, it may be a good idea to issue a VACUUM query. This will update the system catalogs with the results of all recent changes, and allow the Postgres query optimizer to make better choices in planning user queries. -If the server crashes during a VACUUM command, chances are it will leave a lock file hanging around. Attempts to re-run the VACUUM command result in an error message about the creation of a lock file. If you are sure VACUUM is not running, remove the pg_vlock file in your database directory (i.e. PGDATA/base/dbname/pg_vlock). - " {} "Synopsis" {bold} " VACUUM \[ VERBOSE \] \[ ANALYZE \] \[ table \] VACUUM \[ VERBOSE \] ANALYZE \[ table \[ (column \[, ...\] ) \] \] |