Re: [GENERAL] Cancelling of autovacuums considered harmful

2014-04-12 Thread Jan Wieck
On 02/27/14 10:43, Scott Marlowe wrote: On Wed, Feb 26, 2014 at 5:40 PM, Steve Crawford wrote: On 02/26/2014 08:56 AM, Alvaro Herrera wrote: ... No matter how heavily updated, regular activity should not cause autovacuum kills. Only heavier operations would do that (say ALTER TABLE, etc).

Re: [GENERAL] Cancelling of autovacuums considered harmful

2014-02-27 Thread Scott Marlowe
On Wed, Feb 26, 2014 at 5:40 PM, Steve Crawford wrote: > On 02/26/2014 08:56 AM, Alvaro Herrera wrote: >> >> ... >> >> No matter how heavily updated, regular activity should not cause >> autovacuum kills. Only heavier operations would do that (say ALTER >> TABLE, etc). > > > "Considered harmful"

Re: [GENERAL] Cancelling of autovacuums considered harmful

2014-02-26 Thread Steve Crawford
On 02/26/2014 04:40 PM, Steve Crawford wrote: On 02/26/2014 08:56 AM, Alvaro Herrera wrote: ... No matter how heavily updated, regular activity should not cause autovacuum kills. Only heavier operations would do that (say ALTER TABLE, etc). "Considered harmful" got my attention. What, if any,

Re: [GENERAL] Cancelling of autovacuums considered harmful

2014-02-26 Thread Steve Crawford
On 02/26/2014 08:56 AM, Alvaro Herrera wrote: ... No matter how heavily updated, regular activity should not cause autovacuum kills. Only heavier operations would do that (say ALTER TABLE, etc). "Considered harmful" got my attention. What, if any, known harm is caused? We have many errors of

Re: [GENERAL] Cancelling of autovacuums considered harmful

2014-02-26 Thread Jeff Janes
On Wed, Feb 26, 2014 at 1:34 PM, Scott Marlowe wrote: > On Wed, Feb 26, 2014 at 9:56 AM, Alvaro Herrera > wrote: > > Scott Marlowe escribió: > >> As some of you folks know I work on some pretty beefy machines. Some > >> of these machines don't see rest for months or days on end. And > >> autovacu

Re: [GENERAL] Cancelling of autovacuums considered harmful

2014-02-26 Thread Scott Marlowe
On Wed, Feb 26, 2014 at 9:56 AM, Alvaro Herrera wrote: > Scott Marlowe escribió: >> As some of you folks know I work on some pretty beefy machines. Some >> of these machines don't see rest for months or days on end. And >> autovacuum keeps cancelling. I set it more aggressive, it still never >> fi

Re: [GENERAL] Cancelling of autovacuums considered harmful

2014-02-26 Thread Jeff Janes
On Wed, Feb 26, 2014 at 8:15 AM, Scott Marlowe wrote: > As some of you folks know I work on some pretty beefy machines. Some > of these machines don't see rest for months or days on end. And > autovacuum keeps cancelling. I set it more aggressive, it still never > finishes. > > We've now had to sc

Re: [GENERAL] Cancelling of autovacuums considered harmful

2014-02-26 Thread Alvaro Herrera
Scott Marlowe escribió: > As some of you folks know I work on some pretty beefy machines. Some > of these machines don't see rest for months or days on end. And > autovacuum keeps cancelling. I set it more aggressive, it still never > finishes. No matter how heavily updated, regular activity shoul

[GENERAL] Cancelling of autovacuums considered harmful

2014-02-26 Thread Scott Marlowe
As some of you folks know I work on some pretty beefy machines. Some of these machines don't see rest for months or days on end. And autovacuum keeps cancelling. I set it more aggressive, it still never finishes. We've now had to schedule manual vacuums because autovac never finishes on large heav