If you change shared_buffers to 2000, remove the comment and reload, the variable is now 2000. If you comment out the variable and reload again, it is still 2000, not the default.
--------------------------------------------------------------------------- Marc G. Fournier wrote: > On Fri, 6 Aug 2004, Bruce Momjian wrote: > > > Marc G. Fournier wrote: > >> > >> Hrmmm, stupid question here, but why not just change hte postgresql.conf > >> to be those variables that *are* changed from the default, with a simple > >> comment pointing to the documention for the rest? the benefit of that is > >> that at lesat the documentation has fuller descriptions of what the > >> variables are for ... > >> > >> *that* could be easily done after beta ... > > > > Not sure why removing the comments is seen as good myself, but I think > > the idea was that if you comment out something and change the default, > > you assume that commenting it out returns it to the default, though it > > does not. > > 'k, now you've totally confused me ... if you comment something out, and > it doesn't return to the default, where does it go to? > > my understanding was that the 'beef' was that the defaults that are > displayed on each of the variables in postgresql.conf file don't > necessarily match the defaults compiled into the backend ... which, I > *think* is what you meant in the above? :) > > Right now, if you install postgresql, there are various variables > added/set in the postgresql.conf file (notably the stuff that Tom did with > the shared memory buffer) ... with the rest being "what could be the > default, but may not be" for the commented out variables ... my suggestion > is to remove the commented out variables altogether, and change the file > to something like: > > # > # for a complete list of GUC variables, see ... > # > <put 'live/set' variables here> > > > ---- > Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) > Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664 > -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
