diff options
| author | Bruce Momjian | 1997-11-21 18:12:58 +0000 |
|---|---|---|
| committer | Bruce Momjian | 1997-11-21 18:12:58 +0000 |
| commit | 3fa2bb316c92b2c332d18072799d585ab795f131 (patch) | |
| tree | b0c0d668c408c98e498bcd4eaa0c7d3d488e9b11 /src/man | |
| parent | 0889dcd6f7e5ce4999082192884b65203009f6c9 (diff) | |
Remove archive stuff.
Diffstat (limited to 'src/man')
| -rw-r--r-- | src/man/create_table.l | 52 | ||||
| -rw-r--r-- | src/man/purge.l | 61 | ||||
| -rw-r--r-- | src/man/vacuum.l | 10 |
3 files changed, 3 insertions, 120 deletions
diff --git a/src/man/create_table.l b/src/man/create_table.l index 4f0dfad170f..757db8bf0c9 100644 --- a/src/man/create_table.l +++ b/src/man/create_table.l @@ -1,6 +1,6 @@ .\" This is -*-nroff-*- .\" XXX standard disclaimer belongs here.... -.\" $Header: /cvsroot/pgsql/src/man/Attic/create_table.l,v 1.12 1997/10/17 11:35:33 vadim Exp $ +.\" $Header: /cvsroot/pgsql/src/man/Attic/create_table.l,v 1.13 1997/11/21 18:12:54 momjian Exp $ .TH "CREATE TABLE" SQL 09/25/97 PostgreSQL .SH NAME create table \(em create a new class @@ -10,9 +10,6 @@ create table \(em create a new class [\fB,\fP attname type [\fBdefault\fP value] [\fBnot null\fP] [, ...] ]\fB )\fP [\fBinherits\fR \fB(\fR classname [\fB,\fR classname] \fB)\fR] [\fBconstraint\fR cname \fBcheck\fR \fB(\fR test \fB)\fR [, \fBcheck\fR \fB(\fR test \fB)\fR ] ] - [\fBarchive\fR \fB=\fR archive_mode] - [\fBstore\fR \fB=\fR \*(lqsmgr_name\*(rq] - [\fBarch_store\fR \fB=\fR \*(lqsmgr_name\*(rq] .fi .SH DESCRIPTION .BR "Create Table" @@ -70,52 +67,12 @@ must satisfy for an insert or update operation to succeed. Each constraint must evaluate to a boolean expression. Multiple attributes may be referenced within a single constraint. .PP -The optional -.BR store -and -.BR arch_store -keywords may be used to specify a storage manager to use for the new -class. The released version of Postgres supports only \*(lqmagnetic -disk\*(rq as a storage manager name; the research system at UC Berkeley -provides additional storage managers. -.BR Store -controls the location of current data, -and -.BR arch_store -controls the location of historical data. -.BR Arch_store -may only be specified if -.BR archive -is also specified. If either -.BR store -or -.BR arch_store -is not declared, it defaults to \*(lqmagnetic disk\*(rq. -.PP The new class is created as a heap with no initial data. A class can have no more than 1600 attributes (realistically, this is limited by the fact that tuple sizes must be less than 8192 bytes), but this limit may be configured lower at some sites. A class cannot have the same name as a system catalog class. .PP -The -.BR archive -keyword specifies whether historical data is to be saved or discarded. -.IR Arch_mode -may be one of: -.TP 10n -.IR none -No historical access is supported. -.TP 10n -.IR light -Historical access is allowed and optimized for light update activity. -.TP 10n -.IR heavy -Historical access is allowed and optimized for heavy update activity. -.PP -.IR Arch_mode -defaults to \*(lqnone\*(rq. Once the archive status is set, there is -no way to change it. For details of the optimization, see [STON87]. .SH EXAMPLES .nf -- @@ -140,13 +97,6 @@ constraint empcon check (wage > 5.30 and wage <= 30.00), check (name <> '') .fi .nf -- ---Create class foo on magnetic disk and archive historical data --- -create table foo (bar int4) archive = heavy - store = "magnetic disk" -.fi -.nf --- --Create class tictactoe to store noughts-and-crosses --boards as a 2-dimensional array -- diff --git a/src/man/purge.l b/src/man/purge.l index 29d8dc6246c..e69de29bb2d 100644 --- a/src/man/purge.l +++ b/src/man/purge.l @@ -1,61 +0,0 @@ -.\" This is -*-nroff-*- -.\" XXX standard disclaimer belongs here.... -.TH PURGE SQL 11/05/95 PostgreSQL PostgreSQL -.SH NAME -purge \(em discard historical data -.SH SYNOPSIS -.nf -\fBpurge\fR classname [ \fBbefore\fR abstime ] [ \fBafter\fR reltime ] -.fi -.SH DESCRIPTION -.BR Purge -allows a user to specify the historical retention properties of a -class. If the date specified is an absolute time such as \*(lqJan 1 -1987\*(rq, Postgres will discard tuples whose validity expired before -the indicated time. -.BR Purge -with no -.IR before -clause is equivalent to \*(lqpurge before now\*(rq. Until specified -with a purge command, instance preservation defaults to -\*(lqforever\*(rq. -.PP -The user may purge a class at any time as long as the purge date never -decreases. Postgres will enforce this restriction, silently. -.PP -Note that the -.BR purge -command does not do anything except set a parameter for system -operation. Use -.IR vacuum (l) -to enforce this parameter. -.SH EXAMPLE -.nf --- ---Always discard data in the EMP class ---prior to January 1, 1989 --- -purge EMP before "Jan 1 1989" -.fi -.nf --- ---Retain only the current data in EMP --- -purge EMP -.fi -.SH "SEE ALSO" -vacuum(l). -.SH "BUGS AND CAVEATS" -Error messages are quite unhelpful. A complaint about -\*(lqinconsistent times\*(rq followed by several nine-digit numbers -indicates an attempt to \*(lqback up\*(rq a purge date on a relation. -.PP -You cannot purge certain system catalogs (namely, \*(lqpg_class\*(rq, -\*(lqpg_attribute\*(rq, \*(lqpg_am\*(rq, and \*(lqpg_amop\*(rq) due -to circularities in the system catalog code. -.PP -This definition of the -.BR purge -command is really only useful for non-archived relations, since -tuples will not be discarded from archive relations (they are -never vacuumed). diff --git a/src/man/vacuum.l b/src/man/vacuum.l index 5557060e855..46d980540a1 100644 --- a/src/man/vacuum.l +++ b/src/man/vacuum.l @@ -1,6 +1,6 @@ .\" This is -*-nroff-*- .\" XXX standard disclaimer belongs here.... -.\" $Header: /cvsroot/pgsql/src/man/Attic/vacuum.l,v 1.5 1997/09/08 17:49:43 momjian Exp $ +.\" $Header: /cvsroot/pgsql/src/man/Attic/vacuum.l,v 1.6 1997/11/21 18:12:58 momjian Exp $ .TH VACUUM SQL 11/05/95 PostgreSQL PostgreSQL .SH NAME vacuum \(em vacuum a database @@ -11,8 +11,7 @@ vacuum \(em vacuum a database .SH DESCRIPTION .BR Vacuum is the Postgres vacuum cleaner. It opens every class in the database, -moves deleted records to the archive for archived relations, cleans -out records from aborted transactions, and updates statistics in the +cleans out records from aborted transactions, and updates statistics in the system catalogs. The statistics maintained include the number of tuples and number of pages stored in all classes. Running .BR vacuum @@ -38,13 +37,8 @@ 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. .PP -The purge(l) command can be used to control the archive retention -characteristics of a given table. -.PP 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. data/base/dbname/pg_vlock). -.SH "SEE ALSO" -purge(l). |
