Re: Table growing faster than autovacuum can vacuum

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: John R Pierce <pierce(at)hogranch(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Table growing faster than autovacuum can vacuum
Date: 2012-02-15 19:49:14
Message-ID: CAOR=d=21pPr2A7kG16kj3HZDie71kCAsQFjZuu4qGuM=7NUXdw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Feb 15, 2012 at 12:38 PM, John R Pierce <pierce(at)hogranch(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2012-02-15 19:50:25 Re: postgresql-9.0
Previous Message John R Pierce 2012-02-15 19:38:42 Re: Table growing faster than autovacuum can vacuum