Re: effective_cache_size vs units

On Tue, 2006-12-19 at 13:32 -0800, Joshua D. Drake wrote:
> On Tue, 2006-12-19 at 10:01 +0100, Peter Eisentraut wrote:
> > Magnus Hagander wrote:
> > > Is it possible to add an error hint to the message? Along the line of
> > > "HINT: Did you perhaps get your casing wrong" (with better wording,
> > > of course).
> >
> > Or how about we just make everything case-insensitive -- but
> > case-preserving! -- on Windows only?
>
> Or we could simply add a helpful line to the postgresql.conf.

Index: postgresql.conf.sample
===================================================================
RCS
file: /projects/cvsroot/pgsql/src/backend/utils/misc/postgresql.conf.sample,v
retrieving revision 1.199
diff -c -r1.199 postgresql.conf.sample
*** postgresql.conf.sample 21 Nov 2006 01:23:37 -0000 1.199
--- postgresql.conf.sample 19 Dec 2006 21:36:28 -0000
***************
*** 24,29 ****
--- 24,33 ----
# settings, which are marked below, require a server shutdown and
restart
# to take effect.

+ #
+ # Any memory setting may use a shortened notation such as 1024MB or
1GB.
+ # Please take note of the case next to the unit size.
+ #

#---------------------------------------------------------------------------
# FILE LOCATIONS

>
> Sincerely,
>
> Joshua D. Drake
>
>
> >
--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate