Re: Bringing PostgreSQL torwards the standard regarding

Поиск
Список
Период
Сортировка
От Shachar Shemesh
Тема Re: Bringing PostgreSQL torwards the standard regarding
Дата
Msg-id 408E9F81.8030600@shemesh.biz
обсуждение исходный текст
Ответ на Re: Bringing PostgreSQL torwards the standard regarding  ("scott.marlowe" <scott.marlowe@ihs.com>)
Список pgsql-hackers
scott.marlowe wrote:

>I think the answer to all of this would require a lot of code being 
>touched to either make it case fold, costing performance, or the 
>replacement of the default lower cased catalog with upper cased catalog.
>  
>
I'm not the one to decide, but it seems to me that this is not a good 
time to enter such a major change, and may never be. How terrible will 
it be if the system is per server (i.e. - one given to initdb?).

>A more comprehensive solution, one which allowed switching from upper 
>folding to lower folding to no folding, to case insensitive, or some 
>subset of those possibilities results in 
>
>a:  slower backend performance, due to folding case for system catalogs
>b:  touching a helluva lot of backend code to make it possible to fold up 
>or down.
>  
>
Well, if it's only the shared catalogs that are affected, this may not 
be such a big problem (very hopeful tone?)

>I'm not 100% sure on this all, but that seems to be the point Tom and I 
>came to in our discussion, and neither of the two solutions seemed very 
>good at the time.
>  
>      Shachar

-- 
Shachar Shemesh
Lingnu Open Source Consulting
http://www.lingnu.com/



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: PITR Phase 1 - Code Overview (1)
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: [pgsql-advocacy] What can we learn from MySQL?