Re: Table bloat and vacuum - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Table bloat and vacuum
Date
Msg-id dcc563d10811120740w78056860x609f7925116b7929@mail.gmail.com
Whole thread Raw
In response to Table bloat and vacuum  (Jack Orenstein <jack.orenstein@hds.com>)
Responses Re: Table bloat and vacuum
Re: Table bloat and vacuum
List pgsql-general
On Wed, Nov 12, 2008 at 8:13 AM, Jack Orenstein <jack.orenstein@hds.com> wrote:
> My application is running on 7.4. We have one huge table that drives
SNIP
> We're in the process of upgrading to 8.3.4, so I'd appreciate any
> throughs on whether and how this behavior will change with the newer
> release.

You will not believe how much faster 8.3 is, and how much easier
maintenance is.  You'll be like a kid in a candy store for months
looking at and using all the new features in it.  The improvements are
enormous.  Biggest difference for you is that 8.3 can do vacuums in a
background method (it sleeps x milliseconds between pages), can run 3
or more threads, and autovacuum daemon is on by default.  For the most
part, your vacuuming issues will no longer exist.

pgsql-general by date:

Previous
From: "Markus Wollny"
Date:
Subject: Suboptimal execution plan for simple query
Next
From: Adriana Alfonzo
Date:
Subject: Re: Table bloat and vacuum