Postgres Pro
Downloads
Home   >   mailing lists

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

From Scott Marlowe
Subject Re: Table growing faster than autovacuum can vacuum
Date
Msg-id CAOR=d=21pPr2A7kG16kj3HZDie71kCAsQFjZuu4qGuM=7NUXdw@mail.gmail.com
Whole thread Raw
In response to Re: Table growing faster than autovacuum can vacuum  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
Tree view 
On Wed, Feb 15, 2012 at 12:38 PM, John R Pierce <pierce@hogranch.com> wrote:
> so, your ~ monthly batch run could be something like...
>
>    create new partition table
>    copy/insert your 1-2 billion rows
>    vacuum analyze (NOT full) new table
>    vacuum freeze new table
>    update master partition table rules

Just FYI, you can "vacuum freeze analyze;" all at once.

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Table growing faster than autovacuum can vacuum
Next
From: Scott Marlowe
Date:
Subject: Re: postgresql-9.0