From: | Rodrigo Barboza <rodrigombufrj(at)gmail(dot)com> |
---|---|
To: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
Cc: | pgsql-performance <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: auto vaccum is dying |
Date: | 2014-10-04 17:31:33 |
Message-ID: | CANs8QJaVqUeXC2FX6yF=qhaCYsLB-HrZu+F1HJm4n52ww+czrA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
On Thu, Oct 2, 2014 at 12:34 PM, Jeff Janes <jeff(dot)janes(at)gmail(dot)com> wrote:
> On Wed, Oct 1, 2014 at 9:43 PM, Rodrigo Barboza <rodrigombufrj(at)gmail(dot)com>
> wrote:
>
>> Hello, I have a table that receives lots of updates and inserts.
>> Auto vaccum is always being cancelled on that table.
>>
>
> Do you have a scheduled task that clusters or reindexes the table?
>
> Newer versions of PostgreSQL will log the conflicting statement that
> caused the vacuum to cancel.
>
>
I have nothing scheduled, only auto vacuum, but with the default parameters.
>
>
>> One day the database went on standby and I had to act manually to recover.
>>
>
> I'm not sure what that means. Do you mean it stopped accepting commands
> to prevent "wrap around" data loss? Once autovacuum starts running on a
> table in "prevent wrap around", then it no longer voluntarily yields to
> other processes trying to take a conflicting lock.
>
>
Exactly, stopped to prevent wrap around. I think it was because auto vacuum
is being canceled.
>
>> What should I do to avoid auto vaccum cancel?
>>
>
> If you have scheduled jobs that do something on the table that requires a
> lock which conflicts with autovac, then you might want to include a manual
> VACUUM in that job.
>
> Also, what full version are you running?
>
>
I am running postgres 9.1.4 with default auto vacuum parameters. I have
only a scheduled job that runs delete for old tuples. Sometimes it a lot of
tuples. Beside that, no other tasks.
Cheers,
>
> Jeff
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Janes | 2014-10-04 18:12:26 | Re: auto vaccum is dying |
Previous Message | Rodrigo Barboza | 2014-10-04 17:31:09 | Re: auto vaccum is dying |