Re: effective_cache_size vs units - Mailing list pgsql-hackers

From Jim C. Nasby
Subject Re: effective_cache_size vs units
Date
Msg-id 20061228122510.GR71246@nasby.net
Whole thread Raw
In response to Re: effective_cache_size vs units  (Benny Amorsen <benny+usenet@amorsen.dk>)
Responses Re: effective_cache_size vs units  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
On Wed, Dec 27, 2006 at 09:39:22AM +0100, Benny Amorsen wrote:
> >>>>> "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.

Yes, and I can't think of a single reason why we'd let people specify
anything in millibytes, or kilobits. Truth is, I bet many (if not most)
DBAs barely know that case matters in the units. And even those that do
are likely to prefer ease of use to pedantics.

As for the comments about SI datatypes and MySQL-isms, there's a hell of
a big difference between muddying the line in a config file for ease of
use and stomping on data that's actually stored in the database.
-- 
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)


pgsql-hackers by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Dirty pages in freelist cause WAL stuck
Next
From: "Simon Riggs"
Date:
Subject: Re: pg_standby and build farm