Re: How to read query plan

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: How to read query plan
Дата
Msg-id 14079.1110817416@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: How to read query plan  (Miroslav Šulc <miroslav.sulc@startnet.cz>)
Ответы Re: How to read query plan  (Miroslav Šulc <miroslav.sulc@startnet.cz>)
Список pgsql-performance
=?ISO-8859-15?Q?Miroslav_=A6ulc?= <miroslav.sulc@startnet.cz> writes:
> PFC wrote:
>> Instead of a varchar(1) containing 'y' or 'n' you could use a BOOL
>> or an  integer.

> 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.

Just FYI, I did a quick search-and-replace on your dump to replace
varchar(1) by "char", which makes the column fixed-width without any
change in the visible data.  This made hardly any difference in the
join speed though :-(.  So that is looking like a dead end.

John's idea about re-joining to the main table to pick up the bulk of
its fields only after joining to the sub-tables might work.

            regards, tom lane

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

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