Hi all.
I wanted to compare the performances of 2 ways of writing a query,
one using a cartesian join, one using a subselect, to see which
one was the faster.
I used the EXPLAIN command to understand how Postgres
planned to execute them, but the results are a little obscure.
Can somebody shed
[EMAIL PROTECTED] writes:
All this figures confuse me. Which one should i use for
comparison?
The reading of your stopwatch ;-)
The first line's "cost" value is the system's attempt to estimate total
runtime, but it would be foolish to take this as gospel. Especially so
with a pre-7.0
