public inbox for [email protected]  

help / color / mirror / Atom feed

From: Si Chen <[email protected]>
To: [email protected]
Subject: Re: postgresql 8.0 advantages
Date: Fri, 25 Feb 2005 09:20:29 -0800
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>

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 <[email protected]> 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
>
>  
>

view thread (15+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: postgresql 8.0 advantages
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox