Postgres Pro
Downloads
Home   >   mailing lists

Re: Table growing faster than autovacuum can vacuum - Mailing list pgsql-general

From Marti Raudsepp
Subject Re: Table growing faster than autovacuum can vacuum
Date
Msg-id CABRT9RAO5xC-gb-dJJpjrs_7xV49C+6yuNTSyN=ESDBT8Z-C_w@mail.gmail.com
Whole thread Raw
In response to Re: Table growing faster than autovacuum can vacuum  (Marti Raudsepp <marti@juffo.org>)
List pgsql-general
Tree view 
On Wed, Feb 15, 2012 at 19:25, Marti Raudsepp <marti@juffo.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

pgsql-general by date:

Previous
From: Marti Raudsepp
Date:
Subject: Re: Table growing faster than autovacuum can vacuum
Next
From: "Bob Pawley"
Date:
Subject: Re: DDL Triggers