Re: auto vaccum is dying

On Thu, Oct 2, 2014 at 12:34 PM, Jeff Janes <jeff.janes@gmail.com> wrote:

On Wed, Oct 1, 2014 at 9:43 PM, Rodrigo Barboza <rodrigombufrj@gmail.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.

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.