Sami Dalouche wrote:
> -- For some reason, my message doesn't seem to go through the mailing
> list, so I am trying without any attachment
FWIW, you can post EXPLAIN ANALYZE results on the web here:
http://www.explain-analyze.info/
It's a pretty cool utility by Michael Glaesemann that should make
Thanks for your answer.
So, basically, what you are saying is that there is nothing particularly
wrong with the query, nor with its optimization ? So if I need
performance for this query, I should just revert to other techniques
(giving more memory to postgres, caching outside postgres, etc..) ?
Sami Dalouche <[EMAIL PROTECTED]> writes:
> Compare that to the following query, that is exactly the same except
> that the City table is inner'joined instead of outer joined
> ...
> the explain analyze is available at :
> http://www.photosdesami.com/temp/exp6.txt
AFAICS it's just absolutely blind
Sami Dalouche <[EMAIL PROTECTED]> writes:
> -- For some reason, my message doesn't seem to go through the mailing
> list, so I am trying without any attachment
Please don't do that, at least not that way. These explain outputs have
been line-wrapped to the point of utter unreadability.
The main
