aboutsummaryrefslogtreecommitdiff
path: root/src/man/postgres.1
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>1997-08-06 03:42:21 +0000
committerBruce Momjian <bruce@momjian.us>1997-08-06 03:42:21 +0000
commitf5f366e18829c982273540d88a1ac81c9c85d401 (patch)
tree347fc45caa2420d381e963d6b95bd6109085a163 /src/man/postgres.1
parent3bea7b138bbdf6129b36fbdab158526544262980 (diff)
downloadpostgresql-f5f366e18829c982273540d88a1ac81c9c85d401.tar.gz
postgresql-f5f366e18829c982273540d88a1ac81c9c85d401.zip
Allow internal sorts to be stored in memory rather than in files.
Diffstat (limited to 'src/man/postgres.1')
-rw-r--r--src/man/postgres.124
1 files changed, 10 insertions, 14 deletions
diff --git a/src/man/postgres.1 b/src/man/postgres.1
index 940e1822f9f..287e7347931 100644
--- a/src/man/postgres.1
+++ b/src/man/postgres.1
@@ -1,6 +1,6 @@
.\" This is -*-nroff-*-
.\" XXX standard disclaimer belongs here....
-.\" $Header: /cvsroot/pgsql/src/man/Attic/postgres.1,v 1.5 1997/01/26 15:32:20 scrappy Exp $
+.\" $Header: /cvsroot/pgsql/src/man/Attic/postgres.1,v 1.6 1997/08/06 03:42:18 momjian Exp $
.TH POSTGRES95 UNIX 12/08/96 Postgres95 Postgres95
.SH NAME
postgres \(em the Postgres backend server
@@ -79,7 +79,10 @@ is the number of shared-memory buffers that the
.IR "postmaster"
has allocated for the backend server processes that it starts. If the
backend is running standalone, this specifies the number of buffers to
-allocate. This value defaults to 64.
+allocate. This value defaults to 64, and each buffer is 8k bytes.
+.TP
+.BR "-E"
+Echo all queries.
.TP
.BR "-F"
Disable automatic fsync() call after each transaction.
@@ -89,15 +92,17 @@ while a transaction is in progress will probably cause data loss.
.BR "-P" " filedes"
.IR "filedes"
specifies the file descriptor that corresponds to the socket (port) on
-which to communicate to the frontend process. This option is
+which to communicate to the frontend process. This option is
.BR not
useful for interactive use.
.TP
.BR "-Q"
Specifies \*(lqquiet\*(rq mode.
.TP
-.BR "-E"
-Echo all queries.
+.BR "-S"
+Specifies the amount of memory to be used by internal sorts before using
+disk files for sorting. This value is specified in 1k bytes, and
+defaults to 512.
.TP
.BR "-e"
The
@@ -154,15 +159,6 @@ Turns off the locking system.
.BR "-N"
Disables use of newline as a query delimiter.
.TP
-.BR "-S"
-Indicates that the transaction system can run with the assumption of
-stable main memory, thereby avoiding the necessary flushing of data
-and log pages to disk at the end of each transaction system. This is
-only used for performance comparisons for stable vs. non-stable
-storage. Do not use this in other cases, as recovery after a system
-crash may be impossible when this option is specified in the absence
-of stable main memory.
-.TP
.BR "-b"
Enables generation of bushy query plan trees (as opposed to left-deep
query plans trees). These query plans are not intended for actual