Bruce,
Re-building CVS I noticed that I never submitted this doc-only patch to
postgresql.conf.sample.
--
Josh Berkus
Aglio Database Solutions
San Francisco
Index: postgresql.conf.sample
===================================================================
RCS file: /projects/cvsroot/pgsql-server/src/backend/utils/misc/postgresql.conf.sample,v
retrieving revision 1.127
diff -c -r1.127 postgresql.conf.sample
*** postgresql.conf.sample 31 Aug 2004 04:53:44 -0000 1.127
--- postgresql.conf.sample 20 Sep 2004 00:58:28 -0000
***************
*** 11,16 ****
--- 11,19 ----
# allowed values can be found in the PostgreSQL documentation. The
# commented-out settings shown in this file represent the default values.
#
+ # Please note that re-commenting values does NOT revert them to the
+ # default values.
+ #
# Any option can also be given as a command line switch to the
# postmaster, e.g. 'postmaster -c log_connections=on'. Some options
# can be changed at run-time with the 'SET' SQL command.
***************
*** 18,24 ****
# This file is read on postmaster startup and when the postmaster
# receives a SIGHUP. If you edit the file on a running system, you have
# to SIGHUP the postmaster for the changes to take effect, or use
! # "pg_ctl reload".
#---------------------------------------------------------------------------
--- 21,28 ----
# This file is read on postmaster startup and when the postmaster
# receives a SIGHUP. If you edit the file on a running system, you have
# to SIGHUP the postmaster for the changes to take effect, or use
! # "pg_ctl reload". Some settings, such as listen_address, require
! # a full shutdown and restart to take effect.
#---------------------------------------------------------------------------
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
