Re: effective_cache_size vs units

>>>>> "TL" == Tom Lane <tgl@sss.pgh.pa.us> writes:

TL> Anyone against making it case-insensitive, speak now or hold your
TL> peace.

SI-units are inherently case-sensitive. The obvious example is that
now you will allow people to specify an amount in millibytes, while
interpreting it in megabytes.

You are trying to interpret valid input as misspellings based on
context, and then you silently guess at what the user really meant.
That's MySQL behaviour!


/Benny