Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

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

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commitf22f57c

Browse files
committed
Update manual pages for vacuum and create index for Vadim.
1 parent1e790e2 commitf22f57c

File tree

2 files changed

+15
-9
lines changed

2 files changed

+15
-9
lines changed

‎src/man/create_index.l

Lines changed: 8 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -1,14 +1,14 @@
11
.\" This is -*-nroff-*-
22
.\" XXX standard disclaimer belongs here....
3-
.\" $Header: /cvsroot/pgsql/src/man/Attic/create_index.l,v 1.4 1997/01/1317:22:25 momjian Exp $
3+
.\" $Header: /cvsroot/pgsql/src/man/Attic/create_index.l,v 1.5 1997/05/1304:41:51 momjian Exp $
44
.TH "CREATE INDEX" SQL 11/05/95 PostgreSQL PostgreSQL
55
.SH NAME
66
create index\(em construct a secondary index
77
.SH SYNOPSIS
88
.nf
99
\fBcreate\fR [\fBunique\fR]\fBindex\fR index-name
1010
\fBon\fR classname [\fBusing\fR am-name]
11-
\fB(\fR attname [type_class\fB])\fR
11+
\fB(\fR attname, ... [type_class\fB])\fR
1212

1313
\fBcreate\fR [\fBunique\fR]\fBindex\fR index-name
1414
\fBon\fR classname [\fBusing\fR am-name]
@@ -22,12 +22,12 @@ This command constructs an index called
2222
is the name of the access method which is used for the index.
2323
The default access method is btree.
2424
.PP
25-
In the first syntax shown above, the keyfield for the indexis
26-
specified asanattributename and an associated
25+
In the first syntax shown above, the keyfields for the indexare
26+
specified as attributenames. It may also have an associated
2727
.IR"operator class".
2828
An operator class is used to specify the operators to be used for a
29-
particular index. For example, a btree index on four-byte integers
30-
would use the
29+
particular index.
30+
For example, a btree index on four-byte integerswould use the
3131
.IR int4_ops
3232
class; this operator class includes comparison functions for four-byte
3333
integers.
@@ -40,7 +40,7 @@ result of a user-defined function
4040
applied to one or more attributes of a single class. These
4141
.IR"functional indices"
4242
are primarily useful in two situations. First, functional indices can
43-
be used to simulatemultikey indices. That is, the user can define a
43+
be used to simulatemulti-key indices. That is, the user can define a
4444
new base type (a simple combination of, say,\*(lqoid\*(rq and
4545
\*(lqint2\*(rq) and the associated functions and operators on this new
4646
type such that the access method can use it. Once this has been done,
@@ -260,6 +260,7 @@ and
260260
represent the use of
261261
.IR"functional indices"
262262
to simulate multi-key indices.
263+
These are no longer needed now that multi-key indexes are supported.
263264
.PP
264265
The Postgres query optimizer will consider using btree indices in a scan
265266
whenever an indexed attribute is involved in a comparison using one of:

‎src/man/vacuum.l

Lines changed: 7 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,12 +1,12 @@
11
.\" This is -*-nroff-*-
22
.\" XXX standard disclaimer belongs here....
3-
.\" $Header: /cvsroot/pgsql/src/man/Attic/vacuum.l,v 1.3 1997/01/1303:45:33 momjian Exp $
3+
.\" $Header: /cvsroot/pgsql/src/man/Attic/vacuum.l,v 1.4 1997/05/1304:41:54 momjian Exp $
44
.TH VACUUM SQL 11/05/95 PostgreSQL PostgreSQL
55
.SH NAME
66
vacuum\(em vacuum a database
77
.SH SYNOPSIS
88
.nf
9-
\fBvacuum[verbose][\fPtable\fB]\fP
9+
\fBvacuum[verbose][analyze][\fPtable [(column,...)]\fB]\fP
1010
.fi
1111
.SH DESCRIPTION
1212
.BR Vacuum
@@ -20,6 +20,11 @@ periodically will increase Postgres's speed in processing user queries.
2020
.PP
2121
\fBverbose\fP prints a detailed vacuum activity report for each table.
2222
.PP
23+
\fBanalyze\fP also updates column statistics used by the optimizer to
24+
determine the most efficient way to execute a query.
25+
The statistics represent the disbursion of the data in each column.
26+
This information is valuable when several execution paths are possible.
27+
.PP
2328
The open database is the one that is vacuumed.
2429
.PP
2530
We recommend that production databases be vacuumed nightly, in order

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp