Re: Question about VACUUM - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: Question about VACUUM
Date
Msg-id CAOR=d=24U__8V=rB+khFM18by863EwREgFhDfqxy_YkiJiGTyw@mail.gmail.com
Whole thread Raw
In response to Re: Question about VACUUM  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: Question about VACUUM  (Ernesto Quiñones <ernestoq@gmail.com>)
List pgsql-performance
On Mon, Dec 5, 2011 at 10:42 AM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
> On Mon, Dec 5, 2011 at 10:19 AM, Ernesto Quiñones <ernestoq@gmail.com> wrote:
>> vacuum_cost_delay       1s
>> vacuum_cost_limit       200
>
> Those are insane settings for vacuum costing, even on a very slow
> machine.  Basically you're starving vacuum and autovacuum so much that
> they can never keep up.

sorry, the word I meant there was pathological.  No insult intended.

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Question about VACUUM
Next
From: Ernesto Quiñones
Date:
Subject: Re: Question about VACUUM