summaryrefslogtreecommitdiff
path: root/src/man
diff options
context:
space:
mode:
authorBruce Momjian1997-06-02 14:12:40 +0000
committerBruce Momjian1997-06-02 14:12:40 +0000
commit09e41a037e5761a86e981c013b173385c84f5d31 (patch)
tree956df230dd131adc0fc11804d02a1b198fe09e37 /src/man
parent290bef4e05c12ff568ff49dc07920d3677c0d4f9 (diff)
Update man and psqlHelp for new SET GEQO=# option.
Diffstat (limited to 'src/man')
-rw-r--r--src/man/set.l26
1 files changed, 18 insertions, 8 deletions
diff --git a/src/man/set.l b/src/man/set.l
index aa23bcde995..889e35b3ea1 100644
--- a/src/man/set.l
+++ b/src/man/set.l
@@ -1,6 +1,6 @@
.\" This is -*-nroff-*-
.\" XXX standard disclaimer belongs here....
-.\" $Header: /cvsroot/pgsql/src/man/Attic/set.l,v 1.2 1997/06/01 04:23:12 momjian Exp $
+.\" $Header: /cvsroot/pgsql/src/man/Attic/set.l,v 1.3 1997/06/02 14:12:40 momjian Exp $
.TH SET SQL 05/14/97 PostgreSQL PostgreSQL
.SH NAME
set \(em set run-time parameters for session
@@ -28,11 +28,13 @@ See
.IR "built-in" (3)
for more information on available styles.
+.ce 1
+\fBDateStyle Values\fR
+
.if n .ta 5 +15 +40
.if t .ta 0.5i +1.5i +3.0i
.in 0
.nf
-DateStyle
ISO - use ISO 8601-style dates and times
SQL - use Oracle/Ingres-style dates and times
Postgres - use traditional Postgres format
@@ -45,17 +47,21 @@ DateStyle
.IR GEQO
enables or disables the genetic optimizer algorithm. This algorithm is
.IR on
-by default. See the GEQO README for more information.
+by default, which used GEQO for statements of six or more tables.
+See the GEQO README for more information.
+
+.ce 1
+\fBGEQO Values\fR
.if n .ta 5 +15 +40
.if t .ta 0.5i +1.5i +3.0i
.in 0
.nf
-GEQO
- on - turn the genetic optimizer 'on'
- off - duh
+ on - use for statements with 6 or more tables
+ on=10 - use for statements with 10 or more tables
+ off - do not use the genetic optimizer
.fi
-
+The default is on.
.PP
.IR R_PLANS
enables or disables right-hand evaluation of plans. This algorithm is
@@ -68,7 +74,7 @@ by default.
.nf
R_PLANS
on - turn right-hand plan evaluation 'on'
- off - duh
+ off - do not use right-hand plan evaluation
.fi
.SH EXAMPLES
@@ -88,6 +94,10 @@ set DateStyle to 'SQL,European'
.PP
.nf
--
+--Use GEQO for statements with 4 or more tables
+--
+set GEQO to on=4
+--
--Turn off the genetic optimizer
--
set GEQO to 'off'