Re: postgresql 8.0 advantages

From: "Tom Lane" 

> There are some speed improvements in 8.0 too, though that wasn't the
> main focus of the release cycle.  For instance, Lonni Friedman's nearby
> thread reports on a case where 8.0 consistently finds a much better
> query plan for a complex query than prior releases did, because we fixed
> some issues in the GEQO planner module.

Could you give an example or two of the sorts of queries for which 
performance is improved under 8.0 compared with 7.4, please Tom?

Thanks

Julian Scarfe