Re: postgresql 8.0 advantages

Si Chen <schen@graciousstyle.com> 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