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

Commit09e41a0

Browse files
committed
Update man and psqlHelp for new SET GEQO=# option.
1 parent290bef4 commit09e41a0

File tree

2 files changed

+22
-12
lines changed

2 files changed

+22
-12
lines changed

‎src/bin/psql/psqlHelp.h

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -5,7 +5,7 @@
55
*
66
* Copyright (c) 1994, Regents of the University of California
77
*
8-
* $Id: psqlHelp.h,v 1.16 1997/06/01 04:53:44 momjian Exp $
8+
* $Id: psqlHelp.h,v 1.17 1997/06/02 14:12:28 momjian Exp $
99
*
1010
*-------------------------------------------------------------------------
1111
*/
@@ -154,7 +154,7 @@ static struct _helpStruct QL_HELP[] = {
154154
"purge <class_name> [before <abstime>] [after <reltime>];"},
155155
{"reset",
156156
"set run-time environment back to default",
157-
"reset {DateStyle | GEQO}"},
157+
"reset {DateStyle | GEQO | R_PLANS}"},
158158
{"revoke",
159159
"revoke access control from a user or group",
160160
"revoke <privilege[,privilege,...]> on <rel1>[,...<reln>] from \n[public | group <group> | <username>]\n\t privilege is {ALL | SELECT | INSERT | UPDATE | DELETE | RULE}"},
@@ -166,10 +166,10 @@ static struct _helpStruct QL_HELP[] = {
166166
"select [distinct on <attr>] <expr1> [as <attr1>], ... <exprN> [as <attrN>]\n\t[into table <class_name>] [from <from_list>]\n\t[where <qual>]\n\t[order by <attr1>\n\t\t[using <op1>],..<attrN> [[using <opN>] | ASC | DESC]];" },
167167
{"set",
168168
"set run-time environment",
169-
"set DateStyle {ISO | SQL | Postgres | European | US | NonEuropean}\nset GEQO = {ON | OFF}\nset R_PLANS {ON | OFF}"},
169+
"set DateStyle {ISO | SQL | Postgres | European | US | NonEuropean}\nset GEQO = {ON[=#] | OFF}\nset R_PLANS {ON | OFF}"},
170170
{"show",
171171
"show current run-time environment",
172-
"show {DateStyle | GEQO}"},
172+
"show {DateStyle | GEQO | R_PLANS}"},
173173
{"update",
174174
"update tuples",
175175
"update <class_name> set <attr1>=<expr1>,...<attrN>=<exprN> [from <from_clause>] [where <qual>];"},

‎src/man/set.l

Lines changed: 18 additions & 8 deletions
Original file line numberDiff line numberDiff line change
@@ -1,6 +1,6 @@
11
.\" This is -*-nroff-*-
22
.\" XXX standard disclaimer belongs here....
3-
.\" $Header: /cvsroot/pgsql/src/man/Attic/set.l,v 1.2 1997/06/01 04:23:12 momjian Exp $
3+
.\" $Header: /cvsroot/pgsql/src/man/Attic/set.l,v 1.3 1997/06/02 14:12:40 momjian Exp $
44
.TH SET SQL 05/14/97 PostgreSQL PostgreSQL
55
.SH NAME
66
set\(em set run-time parameters for session
@@ -28,11 +28,13 @@ See
2828
.IR"built-in"(3)
2929
for more information on available styles.
3030

31+
.ce1
32+
\fBDateStyleValues\fR
33+
3134
.ifn .ta5+15+40
3235
.ift .ta0.5i+1.5i+3.0i
3336
.in0
3437
.nf
35-
DateStyle
3638
ISO- use ISO 8601-style dates and times
3739
SQL- use Oracle/Ingres-style dates and times
3840
Postgres- use traditional Postgres format
@@ -45,17 +47,21 @@ DateStyle
4547
.IR GEQO
4648
enables or disables the genetic optimizer algorithm. This algorithm is
4749
.IR on
48-
by default. See the GEQO README for more information.
50+
by default, which used GEQO for statements of six or more tables.
51+
See the GEQO README for more information.
52+
53+
.ce1
54+
\fBGEQOValues\fR
4955

5056
.ifn .ta5+15+40
5157
.ift .ta0.5i+1.5i+3.0i
5258
.in0
5359
.nf
54-
GEQO
55-
on-turn the genetic optimizer 'on'
56-
off-duh
60+
on- use for statements with 6 or more tables
61+
on=10-use for statements with 10 or more tables
62+
off-do not use the genetic optimizer
5763
.fi
58-
64+
The default is on.
5965
.PP
6066
.IR R_PLANS
6167
enables or disables right-hand evaluation of plans. This algorithm is
@@ -68,7 +74,7 @@ by default.
6874
.nf
6975
R_PLANS
7076
on- turn right-hand plan evaluation 'on'
71-
off-duh
77+
off-do not use right-hand plan evaluation
7278
.fi
7379

7480
.SH EXAMPLES
@@ -88,6 +94,10 @@ set DateStyle to 'SQL,European'
8894
.PP
8995
.nf
9096
--
97+
--Use GEQO for statements with 4 or more tables
98+
--
99+
set GEQO to on=4
100+
--
91101
--Turn off the genetic optimizer
92102
--
93103
set GEQO to 'off'

0 commit comments

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