Re: How to read query plan

Поиск
Список
Период
Сортировка
От Miroslav Šulc
Тема Re: How to read query plan
Дата
Msg-id 4235AD70.60407@startnet.cz
обсуждение исходный текст
Ответ на Re: How to read query plan  (Harald Fuchs <use_reply_to@protecting.net>)
Список pgsql-performance
Harald Fuchs wrote:

>>Sure I could. The problem is our project still supports both MySQL and
>>PostgreSQL. We used enum('Y','N') in MySQL so there would be a lot of
>>changes in the code if we would change to the BOOL data type.
>>
>>
>
>Since BOOL is exactly what you want to express and since MySQL also
>supports BOOL (*), you should make that change anyway.
>
>
I know that. The time will have to come.

>(*) MySQL recognizes BOOL as a column type and silently uses
>TINYINT(1) instead.
>
>
I've checked that and you are right, but the BOOL is in MySQL from
version 4.1.0 though we could use tinyint instead of enum - our bad choice.

Miroslav

Вложения

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

Предыдущее
От: Miroslav Šulc
Дата:
Сообщение: Re: How to read query plan
Следующее
От: John Arbash Meinel
Дата:
Сообщение: Re: How to read query plan