Re: effective_cache_size vs units - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: effective_cache_size vs units
Date
Msg-id 4589642B.4050200@dunslane.net
Whole thread Raw
In response to Re: effective_cache_size vs units  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Peter Eisentraut wrote:
> Am Mittwoch, 20. Dezember 2006 13:42 schrieb Tom Dunstan:
>   
>> I suppose we should think about mysql refugees at some point, though. I
>> wonder what they do. The documentation is silent on the matter (and all
>> their examples are in lower case). Mysql is generally case insensitive,
>> right?
>>     
>
> Maybe you can make sense of this, but I can't ...
>
>
>   
[lots of amusing non-orthogonal braindead stuff ...]
>
> Better not imitate that.
>
>   

The MySQL treatment of enums is generally quite reprehensible. The 
proposed patch by contrast fits quite well into our existing type 
system, I think. MySQL users migrating will have a bit of work to do.

I don't think their experience has much to teach us (except how not to 
do enums). We should decide on case sensitivity without having reference 
to it.

cheers

andrew


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: column ordering, was Re: [PATCHES] Enums patch v2
Next
From: Chris Browne
Date:
Subject: Stats Collector Oddity