Re: postgresql 8.0 advantages - Mailing list pgsql-general

From Si Chen
Subject Re: postgresql 8.0 advantages
Date
Msg-id 421F5E5D.1010902@graciousstyle.com
Whole thread Raw
In response to Re: postgresql 8.0 advantages  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: postgresql 8.0 advantages  (Lonni J Friedman <netllama@gmail.com>)
Re: postgresql 8.0 advantages  (Jeff Davis <jdavis-pgsql@empires.org>)
List pgsql-general
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@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
>
>
>

pgsql-general by date:

Previous
From: Thomas F.O'Connell
Date:
Subject: Re: LIke and Indicies
Next
From: Tom Lane
Date:
Subject: Re: Possible to run the server with ANSI/ISO string escapeing