Re: Cancelling of autovacuums considered harmful

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
Cc: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Cancelling of autovacuums considered harmful
Date: 2014-02-27 15:43:30
Message-ID: CAOR=d=1FtsohpA8u-AwU26Zn6U3Z2SPdpSEWP-UbpmCB54P4cQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Feb 26, 2014 at 5:40 PM, Steve Crawford
<scrawford(at)pinpointresearch(dot)com> wrote:
> On 02/26/2014 08:56 AM, Alvaro Herrera wrote:
>>
>> ...
>>
>> No matter how heavily updated, regular activity should not cause
>> autovacuum kills. Only heavier operations would do that (say ALTER
>> TABLE, etc).
>
>
> "Considered harmful" got my attention. What, if any, known harm is caused?
>
> We have many errors of this type but in our case most are due to batch
> processes that have a vacuum embedded at appropriate points in the string of
> commands in order to avoid excessive bloat and to ensure the tables are
> analyzed for the following steps. Occasionally the autovacuum triggers
> before the manual but gets canceled.
>
> Any harm?

We have some rather large tables that have never been autovacuumed. At
first I was thinking it was due to pgsql cancelling them due to load
etc. But if it's slony getting in the way then cancelling them is
still harmful, it's just not postgres' fault.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message CS DBA 2014-02-27 15:55:11 Hardware performance
Previous Message Vinay Gupta 2014-02-27 15:39:08 Doubts after evaluating Xlogdump