On Sat, Oct 4, 2014 at 10:31 AM, Rodrigo Barboza <rodrigombu...@gmail.com> wrote:
> > On Thu, Oct 2, 2014 at 12:34 PM, Jeff Janes <jeff.ja...@gmail.com> wrote: > >> On Wed, Oct 1, 2014 at 9:43 PM, Rodrigo Barboza <rodrigombu...@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
