Re: HELP: Urgent, Vacuum problem - Mailing list pgsql-general

From Scott Marlowe
Subject Re: HELP: Urgent, Vacuum problem
Date
Msg-id 1165352960.14565.459.camel@state.g2switchworks.com
Whole thread Raw
In response to Re: HELP: Urgent, Vacuum problem  (Glen Parker <glenebob@nwlink.com>)
Responses Re: HELP: Urgent, Vacuum problem  (Vivek Khera <vivek@khera.org>)
List pgsql-general
On Tue, 2006-12-05 at 14:56, Glen Parker wrote:
> Scott Marlowe wrote:
> > On Mon, 2006-12-04 at 09:56, Schwenker, Stephen wrote:
> >> I'm using version 7.4.2 on solaris.
> >
> > A few points:
> >
> > 4:  Look at migrating to 8.1 or even 8.2 (due out real soon now).  There
> > have been a lot of advances in pg since 7.4, and the upgrade is pretty
> > painless as long as the dump / restore isn't too much of a burden.
>
> I couldn't agree more.  8.* is light years from where 7.4 was.
>    Just do it, you'll be very happy you did.

I recently tossed 8.1 on my workstation which runs a little reporting
application here.  I pointed the app from 7.4 to 8.1 and got a visit
within about an hour from a user, asking if I'd done anything to my
database.  Worrying that I'd made some mistake and he was getting an
error or something, I asked why he'd asked, and his comment was that it
now seemed to be much faster.  I then commenced to breath again.

8.1 is awesome.  I'll be putting 8.2 on my workstation this week.  yee
ha!

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Anything I can do to speed up this query?
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Online index builds (was: [ANNOUNCE] PostgreSQL 8.2