Skip site navigation (1) Skip section navigation (2)

Re: effective_cache_size vs units

From: Benny Amorsen <benny+usenet(at)amorsen(dot)dk>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: effective_cache_size vs units
Date: 2006-12-27 08:39:22
Message-ID: m3hcvhbumd.fsf@ursa.amorsen.dk (view raw or flat)
Thread:
Lists: pgsql-hackers
>>>>> "TL" == Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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



In response to

Responses

pgsql-hackers by date

Next:From: tomasDate: 2006-12-27 09:45:58
Subject: Re: effective_cache_size vs units
Previous:From: Joshua D. DrakeDate: 2006-12-27 06:39:20
Subject: Re: [HACKERS] Patch(es) to expose n_live_tuples and

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group