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=0EzEuqNC1WukgpL9KMSKrfNskdqZdXkaU+Qj4cLt1eFw@mail.gmail.com
Whole thread Raw
In response to Re: Table growing faster than autovacuum can vacuum  (Jasen Betts <jasen@xnet.co.nz>)
List pgsql-general
On Sat, Mar 24, 2012 at 9:40 PM, Jasen Betts <jasen@xnet.co.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.

pgsql-general by date:

Previous
From: Jasen Betts
Date:
Subject: Re: Table growing faster than autovacuum can vacuum
Next
From: Jasen Betts
Date:
Subject: Re: Upgrade questions