Re: Table bloat and vacuum

From: Adriana Alfonzo <adriana(dot)alfonzo(at)venalum(dot)com(dot)ve>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: Jack Orenstein <jack(dot)orenstein(at)hds(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Table bloat and vacuum
Date: 2008-11-12 15:10:45
Message-ID: 491AF1F5.4000109@venalum.com.ve
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)orenstein(at)hds(dot)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, distribucion o uso a personas autorizadas. Si recibio este corre por error, por favor destruyalo. Eventualmentew los correos electonicos pueden ser alterados. Al respecto, CVG Venalum no se hace responsable por los errores que pudieran afectar al mensaje original.

Attachment Content-Type Size
adriana_alfonzo.vcf text/x-vcard 293 bytes

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Webb Sprague 2008-11-12 15:12:33 Using refcursors in application code (php, python, whatever...)
Previous Message Grzegorz Jaśkiewicz 2008-11-12 15:02:31 Re: sort_mem param of postgresql.conf