From c0a9283742a4c372ed56b15c2a6f10e687777f3e Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Sun, 23 Sep 2001 21:52:36 +0000 Subject: Rename collect_* options to more user-friendly names. --- doc/src/sgml/runtime.sgml | 166 +++++++++++++++++++++++----------------------- 1 file changed, 83 insertions(+), 83 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/runtime.sgml b/doc/src/sgml/runtime.sgml index a1a1be8b1a9..8cb1eb364ae 100644 --- a/doc/src/sgml/runtime.sgml +++ b/doc/src/sgml/runtime.sgml @@ -1,5 +1,5 @@ @@ -780,45 +780,6 @@ 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) @@ -940,6 +901,45 @@ env PGOPTIONS='-c geqo=off' psql + + STATS_COMMAND_STRING (boolean) + STATS_BLOCK_LEVEL (boolean) + STATS_ROW_LEVEL (boolean) + + + These flags determine what information backends send to the statistics + collector process: current commands, block-level activity statistics, + or row-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. + + + + + + STATS_RESET_ON_SERVER_START (boolean) + + + If on, collected statistics are zeroed out whenever the server + is restarted. If off, statistics are accumulated across server + restarts. The default is on. This option + can only be set at server start. + + + + + + STATS_START_COLLECTOR (boolean) + + + Controls whether the server 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 server start. + + + + SYSLOG (integer) @@ -1268,49 +1268,6 @@ dynamic_library_path = '/usr/local/lib/postgresql:/home/my_project/lib:$libdir' - - TRANSFORM_NULL_EQUALS (boolean) - - - When turned on, expressions of the form - expr = NULL (or - NULL = expr) are treated as - expr IS NULL, that is, they - return true if expr evaluates to the NULL - value, and false otherwise. The correct behavior of - expr = NULL is to always - return NULL (unknown). Therefore this option defaults to off. - - - - However, filtered forms in Microsoft - Access generate queries that appear to use - expr = NULL to test for - NULLs, so if you use that interface to access the database you - might want to turn this option on. Since expressions of the - form expr = NULL always - return NULL (using the correct interpretation) they are not - very useful and do not appear often in normal applications, so - this option does little harm in practice. But new users are - frequently confused about the semantics of expressions - involving NULL, so we do not turn this option on by default. - - - - Note that this option only affects the literal = - operator, not other comparison operators or other expressions - that are computationally equivalent to some expression - involving the equals operator (such as IN). - Thus, this option is not a general fix for bad programming. - - - - Refer to the User's Guide for related - information. - - - - PORT (integer) @@ -1408,6 +1365,49 @@ dynamic_library_path = '/usr/local/lib/postgresql:/home/my_project/lib:$libdir' + + TRANSFORM_NULL_EQUALS (boolean) + + + When turned on, expressions of the form + expr = NULL (or + NULL = expr) are treated as + expr IS NULL, that is, they + return true if expr evaluates to the NULL + value, and false otherwise. The correct behavior of + expr = NULL is to always + return NULL (unknown). Therefore this option defaults to off. + + + + However, filtered forms in Microsoft + Access generate queries that appear to use + expr = NULL to test for + NULLs, so if you use that interface to access the database you + might want to turn this option on. Since expressions of the + form expr = NULL always + return NULL (using the correct interpretation) they are not + very useful and do not appear often in normal applications, so + this option does little harm in practice. But new users are + frequently confused about the semantics of expressions + involving NULL, so we do not turn this option on by default. + + + + Note that this option only affects the literal = + operator, not other comparison operators or other expressions + that are computationally equivalent to some expression + involving the equals operator (such as IN). + Thus, this option is not a general fix for bad programming. + + + + Refer to the User's Guide for related + information. + + + + UNIX_SOCKET_DIRECTORY (string) -- cgit v1.2.3