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).
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"
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,
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
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
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
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
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
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