Home > mailing lists

auto vaccum is dying - Mailing list pgsql-performance

From	Rodrigo Barboza
Subject	auto vaccum is dying
Date	October 2, 2014 04:43:45
Msg-id	CANs8QJY8gc_A8gSF_nbUgd5Qeg+ARtiYKdB-Pkmay6JUzdmFTQ@mail.gmail.com Whole thread Raw
Responses	Re: auto vaccum is dying Re: auto vaccum is dying
List	pgsql-performance

Hello, I have a table that receives lots of updates and inserts.

Auto vaccum is always being cancelled on that table.

One day the database went on standby and I had to act manually to recover.

What should I do to avoid auto vaccum cancel?

From: Josh Berkus
Date: 01 October 2014, 18:56:43
Subject: Re: Yet another abort-early plan disaster on 9.3

From: Heikki Linnakangas
Date: 02 October 2014, 06:53:20
Subject: Re: auto vaccum is dying