From c969fed7ecd54be6aca27e68a58efb57b2753ba2 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Fri, 21 Sep 2001 03:32:36 +0000 Subject: Give VACUUM its own GUC parameter for memory usage, rather than piggybacking on SortMem. Add documentation for some recently-added GUC parameters that had so far escaped it. --- doc/src/sgml/runtime.sgml | 71 +++++++++++++++++++++++++++++++++++++++++++++-- 1 file changed, 68 insertions(+), 3 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/runtime.sgml b/doc/src/sgml/runtime.sgml index eef78e17a35..55034494dcb 100644 --- a/doc/src/sgml/runtime.sgml +++ b/doc/src/sgml/runtime.sgml @@ -1,5 +1,5 @@ @@ -780,6 +780,45 @@ env PGOPTIONS='-c geqo=off' psql + + COLLECT_STARTCOLLECTOR (boolean) + + + Controls whether the postmaster should start the statistics-collection + subprocess. This is on by default, but may be turned off if you + know you have no interest in collecting statistics. This option + can only be set at postmaster start. + + + + + + COLLECT_RESETONPMSTART (boolean) + + + If on, collected statistics are zeroed out whenever the postmaster + is restarted. If off, statistics are accumulated across postmaster + restarts. The default is on. This option + can only be set at postmaster start. + + + + + + COLLECT_QUERYSTRING (boolean) + COLLECT_BLOCKLEVEL (boolean) + COLLECT_TUPLELEVEL (boolean) + + + These flags determine what information backends send to the statistics + collector process: current queries, block-level activity statistics, + or tuple-level activity statistics. All default to off. Enabling + statistics collection costs a small amount of time per query, but + is invaluable for debugging and performance tuning. + + + + DEBUG_ASSERTIONS (boolean) @@ -1013,7 +1052,7 @@ env PGOPTIONS='-c geqo=off' psql transaction isolation level - DEFAUL_TRANSACTION_ISOLATION (string) + DEFAULT_TRANSACTION_ISOLATION (string) Each SQL transaction has an isolation level, which can be @@ -1201,6 +1240,19 @@ dynamic_library_path = '/usr/local/lib/postgresql:/home/my_project/lib:$libdir' + + PASSWORD_ENCRYPTION (boolean) + + + When a password is specified in CREATE USER or + ALTER USER without writing either ENCRYPTED or + UNENCRYPTED, this flag determines whether the password is encrypted. + The default is off (do not encrypt the password), but this choice + may change in a future release. + + + + TRANSFORM_NULL_EQUALS (boolean) @@ -1285,7 +1337,7 @@ dynamic_library_path = '/usr/local/lib/postgresql:/home/my_project/lib:$libdir' Specifies the amount of memory to be used by internal sorts - and hashes before resorting to temporary disk files. The value + and hashes before switching to temporary disk files. The value is specified in kilobytes, and defaults to 512 kilobytes. Note that for a complex query, several sorts and/or hashes might be running in parallel, and each one will be allowed to use as @@ -1403,6 +1455,19 @@ dynamic_library_path = '/usr/local/lib/postgresql:/home/my_project/lib:$libdir' + + VACUUM_MEM (integer) + + + Specifies the maximum amount of memory to be used by + VACUUM to keep track of to-be-reclaimed tuples. + The value is specified in kilobytes, and defaults to 8192 kilobytes. + Larger settings may improve the speed of vacuuming large tables + that have many deleted tuples. + + + + VIRTUAL_HOST (string) -- cgit v1.2.3