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

From Adriana Alfonzo
Subject Re: Table bloat and vacuum
Date
Msg-id 491AF1F5.4000109@venalum.com.ve
Whole thread Raw
In response to Re: Table bloat and vacuum  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Responses Re: Table bloat and vacuum
List pgsql-general
Please, i wan't recive more mails....

Thanks

Scott Marlowe escribió:
> 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.
>
>

Aviso Legal  Este mensaje puede contener informacion de interes solo para CVG Venalum. Solo esta permitida su copia,
distribuciono uso a personas autorizadas. Si recibio este corre por error, por favor destruyalo. Eventualmentew los
correoselectonicos pueden ser alterados. Al respecto, CVG Venalum no se hace responsable por los errores que pudieran
afectaral mensaje original. 

Attachment

pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Table bloat and vacuum
Next
From: Richard Huxton
Date:
Subject: Re: Very slow queries w/ NOT IN preparation (seems like a bug, test case)