Re: Table growing faster than autovacuum can vacuum

From: Marti Raudsepp <marti(at)juffo(dot)org>
To: Asher Hoskins <asher(at)piceur(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Table growing faster than autovacuum can vacuum
Date: 2012-02-15 17:33:30
Message-ID: CABRT9RAO5xC-gb-dJJpjrs_7xV49C+6yuNTSyN=ESDBT8Z-C_w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Feb 15, 2012 at 19:25, Marti Raudsepp <marti(at)juffo(dot)org> wrote:
> VACUUM FULL is extremely inefficient in PostgreSQL 8.4 and older.

Oh, a word of warning, PostgreSQL 9.0+ has a faster VACUUM FULL
implementation, but it now requires twice the disk space of your table
size, during the vacuum process.

Regards,
Marti

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bob Pawley 2012-02-15 17:42:46 Re: DDL Triggers
Previous Message Marti Raudsepp 2012-02-15 17:25:15 Re: Table growing faster than autovacuum can vacuum