From: "Tom Lane" <tgl@xxxxxxxxxxxxx>
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
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly