Postgres Pro
Downloads
Home   >   mailing lists

Re: auto vaccum is dying - Mailing list pgsql-performance

From Jeff Janes
Subject Re: auto vaccum is dying
Date
Msg-id CAMkU=1ydN2qQ=N2TrCK8Dw_syZHhS2Ju-GF1iemETXk8FB_Efg@mail.gmail.com
Whole thread Raw
In response to Re: auto vaccum is dying  (Rodrigo Barboza <rodrigombufrj@gmail.com>)
List pgsql-performance
Tree view
On Sat, Oct 4, 2014 at 10:31 AM, Rodrigo Barboza <rodrigombufrj@gmail.com> wrote:

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.

So what is in the log files pertaining to this?
 

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.


You are missing 10 minor releases worth of bug fixes, some of which are related to autovacuuming. 

Cheers,

Jeff

pgsql-performance by date:

Previous
From: Rodrigo Barboza
Date:
Subject: Re: auto vaccum is dying
Next
From: Andrey Lizenko
Date:
Subject: query plan question, nested loop vs hash join