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
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 |