Re: How to read query plan

Поиск
Список
Период
Сортировка
От Miroslav Šulc
Тема Re: How to read query plan
Дата
Msg-id 4235BCE8.1090705@startnet.cz
обсуждение исходный текст
Ответ на Re: How to read query plan  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: How to read query plan  (Kaloyan Iliev Iliev <news1@faith.digsys.bg>)
Список pgsql-performance
Tom Lane wrote:

>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.
>
>
I'll try to change the data type to bool but the problem I stand in
front of is that the code expects that SELECTs return 'Y' or 'N' but
what I have found out till now is that PostgreSQL returns 't' or 'f' for
bool data. I think about some solution but they use CPU :-(

>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.
>
>
I'll try that. It seems it could work.

>            regards, tom lane
>
>
Miroslav

Вложения

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

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