Re: Upgrading 6.5.1

From: Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Upgrading 6.5.1
Date: 2002-12-17 05:33:20
Message-ID: 200212170033.20496.lamar.owen@wgcr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Monday 16 December 2002 22:37, Bruce Momjian wrote:
> Jean-Christian Imbeault wrote:
> > 6.5.1 is *really* old. Are there any docs still left lying around on

> > Also, assuming we run the new version on the same hardware what kind of
> > a performance increase should I expect to see. Maybe about 20x faster?

> Let's see --- how fast does dust move --- that would be your 6.5.1
> server. :-)

Hey, I remember that 6.5 was considered a substantial advance from 6.4.... And
it _was_ a notable advance -- 6.5 was the first version that was actually
quite reliable. I still have a production server running 6.5.3 very happily
and speedily.

And I started with 6.2.1, so I know slow.

In fact, I remember a quite interesting bit of PR about 6.5 that proclaimed it
being the development team's final mastery of the codebase inherited from
Berkeley... ;-) That blurb was removed by the time 6.5.1 was released, IIRC.

That's about the time I started building RPMs. I guess that makes me an old
hand? :-D

What I would actually suggest is upgrading in version sequence -- get to 7.0,
then 7.1, then 7.2, then go to 7.3. For a simple database it may not be a
big deal. Provided those version even build on your target OS -- as
PostgreSQL has advanced, its supported OS list has changed. I attempted
building 7.0 awhile back on Red Hat 7.3 awhile back, and it failed quite
badly.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-12-17 05:44:13 Re: ORDER BY random() LIMIT 1 slowness
Previous Message Lincoln Yeoh 2002-12-17 05:24:39 Re: Upgrading 6.5.1