nuderstanding 'explain analyse'

Поиск
Список
Период
Сортировка
От Alexandre Leclerc
Тема nuderstanding 'explain analyse'
Дата
Msg-id 1dc7f0e304111613116532a64b@mail.gmail.com
обсуждение исходный текст
Ответы Re: nuderstanding 'explain analyse'  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-performance
Hello,

I build two SELECT queries, and in one I used COALESCE with a CASE,
and in the second one I used only CASE statements.

When analysing, I'm getting the exact same result, except the cost.
(For now I have so few data that the results are too fragmented.

If the plans for both queries are exactly the same, should I assume
that the cost will also be the same?

Thanks for any help.
--
Alexandre Leclerc

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

Предыдущее
От: Kris Jurka
Дата:
Сообщение: Re: mis-estimation on data-warehouse aggregate creation
Следующее
От: Oleg Bartunov
Дата:
Сообщение: Re: Tsearch2 really slower than ilike ?