Re: Table growing faster than autovacuum can vacuum

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Table growing faster than autovacuum can vacuum
Date: 2012-03-25 04:06:36
Message-ID: CAOR=d=0EzEuqNC1WukgpL9KMSKrfNskdqZdXkaU+Qj4cLt1eFw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, Mar 24, 2012 at 9:40 PM, Jasen Betts <jasen(at)xnet(dot)co(dot)nz> wrote:
>
> have you tried using COPY instead of INSERT (you'll have to insert
> into the correct partition)

triggers fire on copy, but rules do not. So if he has partitioning
triggers they'll fire on the parent table etc.

HOWEVER, that'll be slower than copying to the proper partition to begin with.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jasen Betts 2012-03-25 04:39:38 Re: Upgrade questions
Previous Message Jasen Betts 2012-03-25 03:40:55 Re: Table growing faster than autovacuum can vacuum