Re: Table growing faster than autovacuum can vacuum

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Table growing faster than autovacuum can vacuum
Дата
Msg-id CAOR=d=0EzEuqNC1WukgpL9KMSKrfNskdqZdXkaU+Qj4cLt1eFw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Table growing faster than autovacuum can vacuum  (Jasen Betts <jasen@xnet.co.nz>)
Список 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 по дате отправления:

Предыдущее
От: Jasen Betts
Дата:
Сообщение: Re: Table growing faster than autovacuum can vacuum
Следующее
От: Jasen Betts
Дата:
Сообщение: Re: Upgrade questions