Si Chen <schen@xxxxxxxxxxxxxxxxx> writes: > I read the PostgreSQL 8.0 "What's New" page > (http://www.postgresql.org/docs/whatsnew) and wasn't sure whether > version 8.0 is significantly faster, more scalability, or more stable > than versions 7.4? I remember big speed improvements between 7.3 and > 7.4. It seems the biggest advantage of version 8.0 is being able to run > in Windows. 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. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings