Thanks!
Is there any documentation on how to upgrade to 8.0?
Is it possible to upgrade from 7.4 to 8.0 while keeping a production database running "in place"? Or should I install 8.0 in another directory/machine and then restore the database into it? Are there any incompatibilities/modifications to databases from the earlier veresion required?
(I am running RHEL3.)
Si Chen
Tom Lane wrote:
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 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)
