nuderstanding 'explain analyse' - Mailing list pgsql-performance

From Alexandre Leclerc
Subject nuderstanding 'explain analyse'
Date
Msg-id 1dc7f0e304111613116532a64b@mail.gmail.com
Whole thread Raw
Responses Re: nuderstanding 'explain analyse'
List 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 by date:

Previous
From: Kris Jurka
Date:
Subject: Re: mis-estimation on data-warehouse aggregate creation
Next
From: Oleg Bartunov
Date:
Subject: Re: Tsearch2 really slower than ilike ?